DAX Measure for Distinct Count By Group

[timothywright27]

I have a distinct count measure that correctly counts distinct service months by Member, but I'd like to be able to roll up those member counts to a parent provider.  Any help would be super appreciated, thanks

Member 1 - 2 Service Months

Member 2 - 1 Service Month

Provider A - 3 Service Months

Provider	Member	Service Month
A	1	October
A	1	November
A	2	October

[amitchandak]

Try like this

sumx(summarize(table,table[Member], "_dist", distinctcount(table[Service Month])),[_dist])

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[JarroVGIT · Accepted solution]

Hi @timothywright27 ,

I assume you have the table as your data structure and you want it to show it as the text above the table? Why not using a matrix for that with Count on Service Month?

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂