Matrix measure totals are wrong

[yodha]

Hi, 

I have created a measure to replace "0"s with "blanks" in my matrix. Though it is displaying "blanks" in place of "0"s, showing incorrect totals and other values in the column.

This is my measure:

Measure = IF(MAX('Table'[U])=0,BLANK(),MAX('Table'[U]))

Any help on this please?

Attched sample pbix https://www.dropbox.com/s/zljfwaudp2x8yd4/sample%20report.pbix?dl=0

[parry2k · Accepted solution]

@yodha change your measure

Measure = SUMX ( 'Table',  IF(CALCULATE(MAX('Table'[U]))=0,BLANK(),CALCULATE(MAX('Table'[U]))))

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!