MDX and DAX topics

As Mosha Pasumansky has described in his blog AS2008MDX: subselects and CREATE SUBCUBE in non-visual mode , an MDX subselect performs two f...

It is a well-known best practice in the MDX community to avoid run-time checks by choosing SCOPE over IIF function, and for the same reason,...

Last time I discussed MDX engine limitations in dealing with recursive calculations. Today I want to describe two more situations where use...

The other day, while investigating a customer performance problem, Chris Webb came up with a sequence of very simple and targeted MDX queri...

Automatic cross filtering between columns of the same table or related tables is a very powerful feature of DAX. It allows a measure to eval...