Hide rows in a straight table measure

[D19PAL]

Hi Guys.

I have an if statement and if conditions met = 1.  In the table I only want to show the 1s in the measure, cant turn it into a dimension.

Is there a way?

Thanks

[Or · Accepted solution]

Uncheck "Include 0 values" and make sure your else() doesn't return a value other than 0 or null.

[D19PAL]

Thanks