Forum Discussion
Incorrect Column Totals in Matrix
Hello,
I have the matrix that has been filtered for one category, however, it is showing the incorrect total.
For the other categories, I don't have this issue. The values have been calculated using Measure.
Thank you.
2 Replies
Anonymous This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Hi, Anonymous ;
Try it.
Churn Measure = VAR __Churn = [Value in GBP on last day of Month (2 Months ago) V1] - [Value in GBP on last day of Month (Last Month) V1] RETURN IF(HASONEVALUE('Table'[Customer]), IF(__Churn > 5000000,__Churn,0),__Churn)The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
