Forum Discussion
Shri
6 years agoFrequent Visitor
OR condition between multivalue parameters
I am replicating a power bi report on paginated Report Builder that has multiple slicers (or parameters), namely Sales Region, SalesType, State, Model_Name, Serial_Number, etc. When we run the repo...
amitchandak
6 years agoSuper User
Shri , a filter like this
filter(all(Table),
Table[Sales Region] in values(Table[Sales Region]) || Table[SR_Type] in values(Table[SR_Type])
|| Table[State] in values(Table[State) || Table[Model_Name] in values(Table[Model_Name])
|| Table[Serial_Number] in values(Table[Serial_Number]))
But better have slicer from disconnected table to avoid all