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(DISTINCTCOUNT([Column A]),FILTER(Data,[Column B]="Red" Or "Blue"))
 
So bascially a distinct count of column A filtered when column B is either 'Red' or 'Blue'. I'm not sure what the syntax should be??
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"))

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Try this measure

     

    Cc =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Column A] ),
    FILTER (
        'Table',
        'Table'[Column B]
            IN {
            "Red",
            "Blue"
        }
    )
)

     

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)

    Did I answer your question? Mark my post as a solution!

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , try like

    CALCULATE(DISTINCTCOUNT([Column A]),FILTER(Data,[Column B] in{"Red" , "Blue"}))
  • az38's avatar
    az38
    Community Champion
    6 years ago

    Anonymous 

    you were almost correct

    CALCULATE(DISTINCTCOUNT([Column A]),FILTER(Data,Data[Column B]="Red" || Data[Column B]="Blue"))