Select non zero values in DAX, power BI

[jinsbi]

Hi all,

I have a table visual as below in PBI.

"specific loss prod WEC" is a DAX measure. "Service contract category" is a column from a"data table".

I would like to remove all zero values(highlighted) so that only non zero items are displayed . Kindly help

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your measure [specific loss prod WEC] is written, but please try to check if the result of each 0.00 is actually zero or not (for instance, 0.00032564). In this case, please try replacing a measure to the below.

new measure: =
IF (
    ROUND ( [specific loss prod WEC], 2 ) == 0,
    BLANK (),
    [specific loss prod WEC]
)