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] )
    )
Mirithu's avatar
Mirithu
Icon for Helper II rankHelper II
4 years ago

philouduv Thank you. You are absolutely right. 

I would like to know how to write the DAX formula such that it still gives me the distinct count for every month but the total be the sum of the monthly distinct counts i.e. the total = 56.