Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Rasidul_Hasan
Frequent Visitor

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

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.

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

@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
  )

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

CNENFRNL
Community Champion
Community Champion

CNENFRNL_0-1664071700890.png


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

5 REPLIES 5
CNENFRNL
Community Champion
Community Champion

CNENFRNL_0-1664071700890.png


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Great. 😊

Greg_Deckler
Super User
Super User

@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
  )

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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

Fantastic.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors