Forum Discussion

richrich123's avatar
richrich123
Icon for Helper III rankHelper III
4 years ago

Point in time counts

Evening,   I wonder if anyone could clarify the approach to this as I can't quote get my head around it. I use PBI to report of data (cases) in Dynamics Customer Service Hub. I have all the reporti...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, richrich123 

 

You try changing COUNT to DISTINCTCOUNT. Counts the number of distinct values in a column.

 

If it still doesn't work, can you provide PBIX sample files for testing?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

richrich123's avatar
richrich123
Icon for Helper III rankHelper III
4 years ago

Hi Charlotte, many thanks for your help again. I have changed to DISTINCTCOUNT but the numbers remain the same. With regards to sharing the pbix, I have to be very careful with that as its pointing to our live CRM and with Data protection that could casue a problem. Is there any way to share something that could help thats not going to compromise data protection?

 

Many thanks

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, richrich123 

     

    You can create your own data in a format similar to your source data but not real data to use as an example.

     

    Best Regards