Forum Discussion
Matrix Filter Based on AND OR logic between group of multiple Slicers
Hi All,
I have one Table like the one below,
and there are 4 Groups of slicers. Slicers groups are,
Slicer Group A = Contain Slicer A1 and A2
Slicer Group B = Contain Slicer B1 and B2
Slicer Group C = Contain Slicer C1 and C2
Slicer Group D = Contain Slicer D1 and D2
I want to Filter the Matrix based on user selections in the Slicers Groups. But, there are AND and OR logic between Slicers.
Matrix will be filtered based on this logic = ( Slicer Group A AND Slicer Group B ) OR Slicer Group C OR Slicer Group D
Example Result:
- IF User Select A1 Listed Feed_ID will be 101, 102, 106
- IF User Select A1 and A2, Listed Feed_ID will be 102 (Because Logic is A1 AND A2)
- IF User Select A2 and B1, Listed Feed_ID will be 103 (Because Logic is A AND B)
- IF User Select A2, B1 and C1 Listed Feed_ID will be 102, 103, 104, 107 (Because Logic is {A AND B} OR C})
- IF User Select C1 and D1, Listed Feed_ID will be 102, 104, 107 (Because Logic is C OR D)
- IF User Select A2, B1, C1 and D1, Listed Feed_ID will be 102, 104, 107 (Because Logic is {(A AND B) OR C OR D})
- IF User Select B2, C1 and D1 Listed Feed_ID will be 101, 102, 104, 107 (Because Logic is B OR C OR D)
- IF User Select B2 and D1 Listed Feed_ID will be 101, 102 (Because Logic is B OR D)
Also, I want to Count the number of Unique Feed_ID based on User Filters.
Check the Attached pbix File.
Link: https://drive.google.com/file/d/1L-DZu0LSZtfzLwrFJLKDWj3MseZ6iIah/view?usp=sharing
2 Replies
- lbendlin
Super User
Your only chance at implementing this is to use disconnected tables for ALL of your subgroups, and a measure as visual level filter. Good luck.
- Rasidul_HasanFrequent Visitor
hi lbendlin, can you share a prototype of this sample ?