Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 calcula...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

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.