Solved: Measure - Get DistinctCount by Category

Anonymous · ‎07-24-2022

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

Thanks for your help!

Jihwan_Kim · ‎07-24-2022

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] ) )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎07-24-2022

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] ) )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Anonymous · ‎07-27-2022

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

Measure - Get DistinctCount by Category