Forum Discussion
itsranga
Helper I
Helper Islicer with OR condition
I've added 3 slicers in power bi. It's working as AND condition, but I want OR condition, how do I fix this?
Three slicers
1. Team
2. Business
3. Function
Then i have added some visuals, if i select Slicer OR condition based i want to show the values in the visual how to achieve this?
Im using this Measure
Filter = Var _fir = IF(ISFILTERED(Table[Team]), 1, 0) Var _sec = IF(ISFILTERED(Table[Functional]), 1, 0) Var _Third = IF(ISFILTERED(Table[Business]), 1, 0) var _Fourth = IF(_fir = 1 || _sec = 1 || _Third=1 , 1,0) return _Fourthvisual-level filter Set the filter to include values where the measure equals 1
above measure its working
2 Replies
johnt75Super User
SQLBI did an article and video on this - https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/
itsrangaIm using this Measure
Filter = Var _fir = IF(ISFILTERED(Table[Team]), 1, 0) Var _sec = IF(ISFILTERED(Table[Functional]), 1, 0) Var _Third = IF(ISFILTERED(Table[Business]), 1, 0) var _Fourth = IF(_fir = 1 || _sec = 1 || _Third=1 , 1,0) return _Fourthvisual-level filter Set the filter to include values where the measure equals 1
above measure its working