Forum Discussion

timothywright27's avatar
timothywright27
Frequent Visitor
6 years ago
Solved

DAX Measure for Distinct Count By Group

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

 

ProviderMemberService Month
A1October
A1November
A2October
DAX
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    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! 🙂

2 Replies