Filter Matrics Based on Combination of AND OR Logic from Multiple Slicers (More then 3 Slicer)

[Rasidul_Hasan]

I have 5 Slicers and They are A, B, C, D, & E. I want to Filter Matrics Based on the combination of AND & OR logic between Slicers. Something Like below.

Matrics should be Filtered by =  ( A & B )  ||  ( C & D ) || E

                               Example =    ( A  AND  B )  OR  ( C  AND  D ) OR  E

Can Someone Share with me a prototype build on DAX? Using Connected or Disconnected Table/Slicers will work.

[Greg_Deckler · Accepted solution]

@Rasidul_Hasan That would be something below. Hard to be specific without sample data, etc. Basically an implementation of a Complex Selector. The Complex Selector - Microsoft Power BI Community

Measure =
  VAR __A = SELECTEDVALUE('SlicerTableA'[A])
  VAR __B = SELECTEDVALUE('SlicerTableB'[B])
  VAR __C = SELECTEDVALUE('SlicerTableC'[C])
  VAR __D = SELECTEDVALUE('SlicerTableD'[D])
  VAR __E = SELECTEDVALUE('SlicerTableE'[E])
  VAR __A1 = MAX('Table'[A])
  VAR __B1 = MAX('Table'[B])
  VAR __C1 = MAX('Table'[C])
  VAR __D1 = MAX('Table'[D])
  VAR __E1 = MAX('Table'[E])
RETURN
  SWITCH(TRUE(),
    ( __A = __A1 && __B = __B1 ) || ( __C = __C1 && __D = __D1) || __E = __E1,1,
    0
  )

[CNENFRNL · Accepted solution]

[Rasidul_Hasan]

Great. 😊

[Greg_Deckler · Accepted solution]

@Rasidul_Hasan That would be something below. Hard to be specific without sample data, etc. Basically an implementation of a Complex Selector. The Complex Selector - Microsoft Power BI Community

Measure =
  VAR __A = SELECTEDVALUE('SlicerTableA'[A])
  VAR __B = SELECTEDVALUE('SlicerTableB'[B])
  VAR __C = SELECTEDVALUE('SlicerTableC'[C])
  VAR __D = SELECTEDVALUE('SlicerTableD'[D])
  VAR __E = SELECTEDVALUE('SlicerTableE'[E])
  VAR __A1 = MAX('Table'[A])
  VAR __B1 = MAX('Table'[B])
  VAR __C1 = MAX('Table'[C])
  VAR __D1 = MAX('Table'[D])
  VAR __E1 = MAX('Table'[E])
RETURN
  SWITCH(TRUE(),
    ( __A = __A1 && __B = __B1 ) || ( __C = __C1 && __D = __D1) || __E = __E1,1,
    0
  )

[Rasidul_Hasan]

Hi @Greg_Deckler , Is this solution for the Connected model With Slicers or Discounted Model with Slicers?

[Rasidul_Hasan]

Fantastic.