Matrix Filter Based on AND OR logic between group of multiple Slicers

[Rasidul_Hasan]

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

[lbendlin]

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_Hasan]

hi @lbendlin, can you share a prototype of this sample ?