Forum Discussion

redsailbi's avatar
redsailbi
Frequent Visitor
3 years ago
Solved

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 fi...
data protection
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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