Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Distinct Count based on multiple OR conditions

For this new measure, I need a distinctcount  of column A if column B has "true" or "neutral"  and column C has "yes" or "maybe"

 

Column AColumn BColumn C
LLtrueyes
LLfalseno
PPneutralno
BB

true

maybe
BBtrueno

 

The result should be 2.  Can you help me with the dax formula?

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This measure works

    Measure = CALCULATE(DISTINCTCOUNT(Data[Column A]),(Data[Column B]="true"||Data[Column B]="neutral"),Data[Column C]="yes"||Data[Column C]="maybe")

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

    Have a try

     

     

    Count = CALCULATE(COUNTROWS(VALUES(yourTable[Column A])),FILTER(yourTable,yourTable[Column B] IN {"true","neutral"} && yourTable[Column C] IN {"yes", "maybe"}))

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    This measure works

    Measure = CALCULATE(DISTINCTCOUNT(Data[Column A]),(Data[Column B]="true"||Data[Column B]="neutral"),Data[Column C]="yes"||Data[Column C]="maybe")