Forum Discussion
rmalhan12
3 years agoFrequent Visitor
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(AUM...
HotChilli
3 years agoCommunity Champion
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)