Forum Discussion

Sebastian_N1's avatar
Sebastian_N1
Regular Visitor
8 years ago
Solved

Slicer showing unselected values

So I have a slicer that filters out employees based on thier supervisor. When i try to exclude a supervisors team, that supervisors team still shows but they are just blank. This issue strted when i ...
  • BrianMiller's avatar
    BrianMiller
    8 years ago

    You should be able to use the filter on the measure to only show when the measure is greater than zero.  This will eliminate the empty rows.

  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi Sebastian_N1,

     

    As a general solution, you can add an if condition to wrap your measure like pattern below:

    Average of SF% =
IF ( CALCULATE ( aggregation ) <> BLANK (), CALCULATE ( aggregation ) )

    Regards,

    Jimmy Tao

BrianMiller's avatar
BrianMiller
Regular Visitor
8 years ago

You should be able to use the filter on the measure to only show when the measure is greater than zero.  This will eliminate the empty rows.