Count distinct values

[giuliapiazza94]

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 · Accepted solution]

Here's some DAX to get your results.

count(sales/name) =

CALCULATE(

DISTINCTCOUNT('Table'[name]),

ALLEXCEPT('Table', 'Table'[Sales])

)

[giuliapiazza94]

Works very well! Thank you so much 😊