Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have the following formula in a measure,
=Count({<FIELD={'text_match'}>}[FIELD])
Where the result is > 0 i would like the result to appear, but if the result is 0 i would like null to appear in the cell rather than 0, is that possible ?
If(Count({<FIELD={'text_match'}>}[FIELD])= 0, Null(), Count({<FIELD={'text_match'}>}[FIELD]))