Grand Total as sum of three measures is wrong

[Silver75]

Hi everyone,

I can't obtain the correct sum, it's very diffucult to me.

This is my table in PowerBI

 

The Grand Total as sum of measure4 is wrong.

Could you suggest to me a correct dax, please?

thank you

[v-huizhn-msft]

Hi @Silver75,

For your measure4, why the logic is different for different products? Please use HASONEFILTER function in your measure 4 like the following similar formula in this article, and check if it works fine. If this still not work, please share your sample table or .pbix file for further analysis?

Best Regards,
Angelia

[lovermann]

But where is your grand total value? Show us the wrong calculated Grand Total.