Forum Discussion

jinsbi's avatar
jinsbi
New Member
4 years ago
Solved

Select non zero values in DAX, power BI

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's avatar
    Jihwan_Kim
    4 years ago

    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]
)

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    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]
)