Apply filter only when the attribute in the slicer is selected

[tuncay]

I've built up a ranking in Power BI. However, sometimes there are some missing data. For example, I get a 0 for the KPI: OEE, even tough there can't be 0 OEE. → OEE is not 0 but as no data comes in for the production plant, so it marks it as 0.

I want to add a filter that it only shows OEE above 0. However, when I do this, all production plants with 0EE = 0 get removed from the Ranking. Also from the other KPI rankings. My aim is only remove it when I select OEE from the slicer (on the right). I want to apply the same for the other KPIs.

How does this work?

Thank you!

[Ashish_Mathur]

Hi,

What measure have you used?

[tuncay]

I tried to first add a "Check measure" which checks whether OEE is selected:

Check OEE = 
IF (
SELECTEDVALUE ( main_KPI[Attribute] )="OEE",
1,
0
)

Then I just need another measure which excludes all 0 from the Ranking when "Check OEE" = 1...

[tuncay]

Something like this...

Zero Row Filter OEE = 
IF (AND ( [Check OEE] = 1, [OEE] = 0), EXLUDE THE FACTORIES, DONT EXCLUDE)