Replace zeros with nulls on a table

[Anonymous]

I have been provided a Sales Revenue measure which needs to be displayed in a table visualization and evaluated according to several dimensions. When graphed, the column produces the right numbers, but most of them turn to be zero. I want to replace all zero values to blank spaces or nulls. Can someone help me reach this goal?

[mwegener]

Hi @Anonymous ,

is your problem solved?

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[mwegener]

Hi @Anonymous ,

try this

Measure = IF(SUM('Table'[Value]) = 0, BLANK(), SUM('Table'[Value]))

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.