Forum Discussion
MEFOX
Helper III
4 years agoTotal incorrect
I'm using the table visual. I've turned on Totals in the Format section and I get a Total that is incorrect. The Total should be 584. Can someone give me some ideas of what might cause this. Is there...
Anonymous
4 years agoNot applicable
Hi MEFOX
Please try this formula :
Measure = CALCULATE(COUNT('CRM FactEvents'[ContactID]),FILTER('CRM FactEvents','CRM FactEvents'[ContactID]<>BLANK()))
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.