How to return BLANK instead of zero

How to return BLANK instead of zero in a DAX measure: Using this technique, you can remove rows in a Power BI matrix visual where the result of a measure is zero.

[tARasKoni]

It's black belt technique, Sensei! Thanks a lot, Marco

[abhijeetghosh]

WoW.. small change big impact... Thanks @Alberto & SQLBI for sharing this.. 👍👍

[christopherhaas]

This is a really elegant solution, thanks SQLBI!

[wayneedmondson]

Great lesson! Thanks for illustrating and demonstrating this technique. Thumbs up!!

[gaetandemers]

That was exactly what I needed, thanks

[김차수-ku]

Greate! i used to use if satement when dealing with 0 and blank() value, i'll try to like thay way~~~

[olemew]

Why does the IF measure scan the table twice? Once you calculate the VAR, in the RETURN piece you are working with scalars, right? Moreover, isn't DIVIDE() an if-else behind the scenes too? Why scan the table again for the last IF block?

[casst]

how do you delete the row if the dax measure returns a zero value as a result of your dax formula in pwr pivot?

[supersayan]

Why cant you use the substitute function to replace 0 with blank?

[mshparber]

9:22 What about cleaning the cache before running the second time? Otherwise this is not a clean comparison...