Forum Discussion
Total is wrong
Hello, I have calculated measure Total_LC as given below Total_LC = VAR F12 = SUM('NCC Chart''s'[F12]) VAR H12 = SUM('NCC Chart''s'[H12]) RETURN (average('NCC Chart''s'[Net_NCC_Cost])+ ...
Hi Anonymous,
This is a common issue, you could refer to these links which explain why and how to resolve it:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/
Regards,
Daniel He