Forum Discussion
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...
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
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
Thanks. I'm still trying to learn some of the ins & outs of Power BI, and this was helpful.