Forum Discussion
Post ProdigyCount 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
- amitchandak
Super User
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
gauravnarchalamitchandak - It should work but it is not working. I have checked the interactions and it is turned ON.
- amitchandak
gauravnarchal ,Can you share sample data and sample output in table format?
