Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX: Distinct count with multiple filters

Hi, I'm quite new to DAX and I don't seem to get a good formula for the below calculation. I have many products that were sold over the years. Now, I want to distinct count the products that were ...
Jos_Woolley's avatar
Jos_Woolley
Icon for Solution Sage rankSolution Sage
5 years ago

Hi,

Distinct_Vol>50_Year2021 =
CALCULATE (
    DISTINCTCOUNT ( Sales[Product] ),
    'Calendar'[Year] = 2021,
    Sales[Volume] > 50
)

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks Jos, however this is not working, please find more info on figure below:

     

  • Peppermint_T's avatar
    Peppermint_T
    Frequent Visitor
    4 years ago

    Great simple & elegant solution. Thank you.