Distinct Count based on multiple OR conditions

[Anonymous]

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 A	Column B	Column C
LL	true	yes
LL	false	no
PP	neutral	no
BB	true	maybe
BB	true	no

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

[Ashish_Mathur · Accepted solution]

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

[Anonymous]

Thank you, this worked!!

[Ashish_Mathur]

You are welcome.

[Vera_33]

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"}))