Customer Count by Groups - Not adding up

[rmalhan12]

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. 

[HotChilli]

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)

[Jos_Woolley]

Hi,

And there are no blanks in the Owner1_Id field?
Regards