Matrix Row Grand Total no working with measure

[Anonymous]

I added an If Then measure. It is not showing the correct Total. I'm only getting the "if"/first part sum not all of the values. The total should be 197,094,457. The 5 mil is only some of the records.

[Anonymous · Accepted solution]

HI @Anonymous,

It looks like a common multiple aggregate calculations issue on measure expression.
For this scenario, you can try to add a variable with summarize function to aggregate records, then you can use the iterator function to apply the second-level aggregation to fix this issue.

Reference link:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin. I followed your example and I got it to work. This is a little crazy.

Can you point me if the direction where I can read up more on proper terminoly for stuff like __value or __table. Why is it who underscores and stuff like that. Coming from SQL syntax is a little different and not exactly obvious.

Best.