Forum Discussion
Counting Distinct Combinations
Hi gambleave ,
I have created a data sample for test.
Could you please tell me what's your expected output? Refer to:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Does this work?
Measure 1 = DISTINCTCOUNT(ServiceHistory[Activity ID])
Measure 2 = SUMX(FILTER(SUMMARIZE(generate(values(ServiceHistory[Client Name]),values(ServiceHistory[Employee Name])), ServiceHistory[Client Name], ServiceHistory[Employee Name]),"ABCD",[Measure 1]),ServiceHistory[Service Type]="High Touch"),[ABCD])
If this does not work, then share the link from where i can download your PBI file and show the expected resutl very clearly.
Thank you very much for your help Ashish!