Forum Discussion
Total is coming incorrect at parent level in matrix visual.
Hi,
I wrote a measure which was giving the result correct at last level but when I drill up the numbers/total is not coming correct. Can someone please help to resolve it.
I am attching the pbix file with the measure and the sample data.
Here is the PBIX file Link
https://drive.google.com/file/d/1a1yRBN06B86j4L-AoNruRpMmvjg6yWZv/view?usp=share_link
Amit
HI redsailbi,
It seems like a common measure total issue when it tries to apply multiple level aggregation to the expression. I'd like to suggest you refer to Greg’s blog to know how to handle with this scenario:
Measure Totals, The Final Word
Notice: add a variable with SUMMARIZE function to calculate hit the first level aggregate, then use iterator function to apply the second level on the variable with calculated records from previous step.
Regards,
Xiaoxin Sheng
1 Reply
HI redsailbi,
It seems like a common measure total issue when it tries to apply multiple level aggregation to the expression. I'd like to suggest you refer to Greg’s blog to know how to handle with this scenario:
Measure Totals, The Final Word
Notice: add a variable with SUMMARIZE function to calculate hit the first level aggregate, then use iterator function to apply the second level on the variable with calculated records from previous step.
Regards,
Xiaoxin Sheng