topic Re: Filter Matrics Based on Combination of AND OR Logic from Multiple Slicers (More then 3 Slicer) in DAX Commands and Tips

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

Rasidul_Hasan — Sat, 24 Sep 2022 13:24:11 GMT

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.

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

Greg_Deckler — Sat, 24 Sep 2022 14:19:36 GMT

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 )

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

CNENFRNL — Sun, 25 Sep 2022 02:09:11 GMT

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

Rasidul_Hasan — Sun, 25 Sep 2022 14:56:01 GMT

Fantastic.

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

Rasidul_Hasan — Sun, 25 Sep 2022 14:56:42 GMT

Great. 😊

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

Rasidul_Hasan — Mon, 26 Sep 2022 08:08:13 GMT

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