Forum Discussion
Count Customers Over Time Using DISTINCTCOUNT
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?
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.