Forum Discussion

Tito's avatar
Tito
Helper IV
2 years ago
Solved

DISTINCTCOUNT DAX

Hello everyone, I have calculated the number of clients using the "DISTINCTCOUNT" function. Now I need a slicer so that I can filter according to the number of clients, i.e. the number less than or ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Tito ,

     

    I made simple samples and you can check the results below:

     

    Measure = var _COUNT = CALCULATE(DISTINCTCOUNT('Table'[Clients]),ALLEXCEPT('Table','Table'[Name]))
RETURN IF(_COUNT<=2,1,0)

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Tito ,

 

I made simple samples and you can check the results below:

 

Measure = var _COUNT = CALCULATE(DISTINCTCOUNT('Table'[Clients]),ALLEXCEPT('Table','Table'[Name]))
RETURN IF(_COUNT<=2,1,0)

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • Tito's avatar
    Tito
    Helper IV
    2 years ago

    Hi Anonymous ,
    Thank you for your reply. This has helped me. Instead of "Measure" I have used a "calculated column".