Forum Discussion

jdballard30's avatar
jdballard30
Helper II
7 years ago
Solved

DistinctCount with summarize

My data involves Applications, Contacts and Programs. Applications have contacts, and can be associated with a program. However, it's possible that a contact can be associated with a program, but not...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi jdballard30,

     

    You had the calculation correct. You just need to add the Program.ProgramStartDate on your columns drill down on the last level of the matrix and remove the subtotals on start date level and it will work.

     

    Check the PBIX attach.

     

    Regards,

    MFelix

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi jdballard30,

 

It seems that the solution from MFelix should be helpful.

 

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please feel free to ask.

 

Best Regards,

Cherry