Measure - Get DistinctCount by Category

[Anonymous]

Hi all,

I'm finding it tricky to get the DistinctCount filtered or grouped by a Category.

For example, with the below sample data, the Distinctcount ("ID") for Monday is 3, Tuesday is 1, Wednesday is 2, Thursday is 4.

I want the measure to tell me the SUM of the above, so 3 + 1 + 2 + 4 = 10

ID	Day of the Week
1	Monday
1	Monday
2	Monday
3	Monday
2	Tuesday
2	Tuesday
2	Wednesday
3	Wednesday
3	Thursday
4	Thursday
5	Thursday
6	Thursday

Thanks for your help! 

[Anonymous]

Thanks so much - that's what I was looking for!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Distinct count ID measure: =
SUMX (
    VALUES ( Data[Day of the Week] ),
    CALCULATE ( DISTINCTCOUNT ( Data[ID] ) )
)