Forum Discussion
Count Customers Over Time Using DISTINCTCOUNT
Counting Customers Over Time Using DISTINCTCOUNT
How can I get a unique count of “Client Group” over time using DISTINCTCOUNT?
I have used the below measure, but it is not working, when I put the date range through a slicer. The count does not change.
ClientCount = DISTINCTCOUNT(Client Group)
Hi gauravnarchal ,
You could refer to my sample and create relationship between calendar date and fact table date.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
gauravnarchal , It should if month year in slicer is related to date in this table.
Or check if interactions are off.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
amitchandak - It should work but it is not working. I have checked the interactions and it is turned ON.
gauravnarchal ,Can you share sample data and sample output in table format?
