Forum Discussion

Mirithu's avatar
Mirithu
Icon for Helper II rankHelper II
4 years ago
Solved

Remove Distinct Count From Grand Total

Hi, I have a common problem with incorrect grand totals but cannot seem to get a solution from previous posts.   I have data with customer numbers and dates columns. I am calculating the distinct ...
Need Help
  • Mirithu's avatar
    Mirithu
    4 years ago

    Thank you philouduv 

     

    I also used this formula and it also works:

     

    Correct Total =
    IF( HASONEVALUE( Calendar[Month Name] ),
    [No of Customers],
    SUMX( VALUES( Calendar[Month Name] ), [No of Customers] )
    )
philouduv's avatar
philouduv
Icon for Resolver III rankResolver III
4 years ago

It is because in total you have 42 different customer in your entire table so the total reflect that without filtering by month ,some customers appears 2 times in your different months that's why the total by month is higher than for the entire year.

Best regards,