Forum Discussion

Rasidul_Hasan's avatar
Rasidul_Hasan
Frequent Visitor
3 years ago

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

  • 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.