Incorrect Column Totals in Matrix

[Anonymous]

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.

[v-yalanwu-msft]

Hi, @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.

[Greg_Deckler]

@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/547907