Forum Discussion

rmalhan12's avatar
rmalhan12
Frequent Visitor
3 years ago

Customer Count by Groups - Not adding up

I am trying to get a count of customers per month (based on selected report date in a slicer). The formula used for total clients is as below -
 
CurrentPeriodClients = CALCULATE(DISTINCTCOUNT(AUMReport[Owner1_Id]))
 
Total number of clients is correct as below -

 

However when I add a slicer to show clients by different groups they don't add up to the value above as below -

Total equals 53,439 

 

The client ID will only appear once under one of the 4 groups therefore no duplication. Any ideas or help to solve this problem? 

 

Thanks in advance. 

 
 
Need Help
Show and Tell
Tips and Tricks

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    3 years ago

    CurrentPeriodClients is a measure?  Can you explain why the Calculate is there?

    --

    What does the data model look like?

    ------

    Use the Data view screen to filter for specific 'groups'.  If you select the Owner1_Id column , you will get summary statistics at the bottom of the screen.  See which figures are wrong (and investigate)