Forum Discussion
idrabble
9 years agoFrequent Visitor
Help with complex DAX measure
Hi everyone, after spending a few hours going round in circles on this one, I thought it was time to ask the experts My company measures performance of new customers in terms of a conquest. ...
- 9 years ago
Hi idrabble
From my understanding that would be due to the fact that when the measure is being calculated in the Matrix it is doing it in the row context of the matrix.
So when the total is calculated there is no row context, so the measure is then defaulting to the zero condition of the measure.
If you want this to be calculated correctly, my best advice is you will need to do the following example from the Power Pivot Pro, which explains in detail how to get this working as expected.