Distinct count on the date based on the grouping Key and categorize it - DAX

Hi chandishd,

Based on my test, you can refer to below steps:

1.I have entered some sample data to test for your problem like the picture below.

2.

2.Create a measure and a calculated column.

Measure = COUNT(Sheet1[ID])

Type = IF([Measure]=1,"Single","Many")

3.Create two Table visual and a Slicer visual and add the related fields. Now you can see the result.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/cugktmidockb19y/Distinct%20count%20on%20the%20date%20based%20on%20the%20grouping%20Key%20and%20categorize%20it%20-%20DAX.pbix?dl=0

Regards,

Daniel He

Thank you v-danhe-msft 

Hi chandishd,

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,
Daniel He