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 measur...
  • 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])
    )
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])
)
giuliapiazza94's avatar
giuliapiazza94
Icon for Helper IV rankHelper IV
5 years ago

Works very well! Thank you so much ðŸ˜Š