Forum Discussion
Solved
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 th...
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.
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?