Forum Discussion

jkernen's avatar
jkernen
Frequent Visitor
6 years ago
Solved

AND vs OR in filter slicers

Data:  C1       C2 Tom X   Tom Y   Paul X   Paul Y   Vince X   Vince Z         I want to filter out the people who has both X & Y. (not X or Y)  In this case...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi jkernen 

     

    Kindly find my results:

    Measure 2 = var a = ALLSELECTED('Table 2'[C2])
Return IF(CALCULATE(DISTINCTCOUNT('Table'[C2]),'Table'[C2] in a)=COUNTROWS(a),MAX('Table'[C1]))

    Pbix attached.

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi jkernen 

 

Kindly find my results:

Measure 2 = var a = ALLSELECTED('Table 2'[C2])
Return IF(CALCULATE(DISTINCTCOUNT('Table'[C2]),'Table'[C2] in a)=COUNTROWS(a),MAX('Table'[C1]))

Pbix attached.

jkernen's avatar
jkernen
Frequent Visitor
6 years ago

 is is possible to do this without creating a second data-table?