Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter Using Dax

Hi experts,    quick question, I'm trying to write a measure to calculate a distinct count of a column when that column is either of two possible filters. So something like this;    CALCULATE(DI...
Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    you were almost correct

    CALCULATE(DISTINCTCOUNT([Column A]),FILTER(Data,Data[Column B]="Red" || Data[Column B]="Blue"))
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , try like

CALCULATE(DISTINCTCOUNT([Column A]),FILTER(Data,[Column B] in{"Red" , "Blue"}))