slicer with OR condition

[itsranga]

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?

[itsranga · Accepted solution]

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
_Fourth

visual-level filter Set the filter to include values where the measure equals 1

above measure its working

[johnt75]

SQLBI did an article and video on this - https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/