Forum Discussion

MEFOX's avatar
MEFOX
Icon for Helper III rankHelper III
4 years ago

Total 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...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

MEFOX That total just means that some [ContactID] are in more than 1 [Type] so in the total they only get counted once (DISTINCTCOUNTNOBLANK).  Try it with a SUMX over the [Type].

Registered =
SUMX (
    VALUES ( 'CRM FactEvents'[Type] ),
    CALCULATE ( DISTINCTCOUNTNOBLANK ( 'CRM FactEvents'[ContactID] ) )
)
MEFOX's avatar
MEFOX
Icon for Helper III rankHelper III
4 years ago

Your solution works when there is just Type and Registered in the table but when I add the date column it no longer provides the correct Total.