Forum Discussion

giuliapiazza94's avatar
giuliapiazza94
Icon for Helper IV rankHelper IV
5 years ago
Solved

Count distinct values

Hi guys,

This is my problem

 

I want to count how many name for each sales: for example, A has got 2 name and I need to create a new column with the number 2 (like in the picture). No measure

 

Thank you all

you are always very kind 🙂

  • PaulOlding's avatar
    PaulOlding
    5 years ago

    Here's some DAX to get your results.

     

    count(sales/name) =
    CALCULATE(
    DISTINCTCOUNT('Table'[name]),
    ALLEXCEPT('Table', 'Table'[Sales])
    )

2 Replies

  • PaulOlding's avatar
    PaulOlding
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Here's some DAX to get your results.

     

    count(sales/name) =
    CALCULATE(
    DISTINCTCOUNT('Table'[name]),
    ALLEXCEPT('Table', 'Table'[Sales])
    )