Watch Those DAX Calculations

Kevin Feasel

2015-12-18

DAX

Chris Webb shows us a case in which Power BI Desktop’s DAX calculation might not be what you expect:

The difference here is that the Month Number and Month Name fields are both present – they have to be since the query has to sort by Month Number. In MDX the order of members on a hierarchy can be set inside the model; in a DAX query you can only sort using an ORDER BY clause and for that to work, the field you’re ordering by must be present in the query.

This kind of feels like an edge case, but if you run into it, it’s good to know that it’s not a bug.

Related Posts

The TREATAS Function In DAX

Kevin Feasel

2017-12-07

DAX

Matt Allington explains what the TREATAS function does: The TREATAS function can be used to detect filters from your visual (filter context) and then apply these filters to a disconnected table in your data model. It takes a source table (first parameter) and applies the values from that table to columns in a target table (second […]

Read More

Replacing DAX PathContains With OR

Chris Koester shows the performance benefits of replacing the PathContains function in DAX with a simple OR operator: This post shows how you can generate optimized multi-value DAX parameters in SSRS and achieve greater performance compared to the DAX PathContains function. This will be a short post that provides the SSRS expression to convert multiple SSRS parameters […]

Read More

Categories

December 2015
MTWTFSS
« Nov Jan »
 123456
78910111213
14151617181920
21222324252627
28293031