Total is coming incorrect at parent level in matrix visual.

[redsailbi]

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  

[v-shex-msft · Accepted solution]

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