Count Customers Over Time Using DISTINCTCOUNT

[gauravnarchal]

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)

[amitchandak]

@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

[gauravnarchal]

@amitchandak - 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?

[gauravnarchal]

@amitchandak - Here below is the data and output.

[dax · Accepted solution]

Hi @gauravnarchal , 

You could refer to my sample and create relationship between calendar date and fact table date.

Best Regards,
Zoe Zhi

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