Forum Discussion

bswank31's avatar
bswank31
Helper II
2 years ago
Solved

Grand Total not adding correctly

Hi. I have searched for an answer but I cannnot quite get anything to work. I have a column that is counting the number of rigs. Sum of Rigs max per Date = MAXX(     KEEPFILTERS(VALUES('Calendar ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi bswank31 ,

     

    Try to modify your formula like below, it can get correct total result:

     

    result1 = 
CALCULATE (
    MAXX (
        KEEPFILTERS ( VALUES ( 'Calendar'[Date] ) ),
        CALCULATE ( SUM ( 'Drill'[Rigs] ) )
    )
)

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi bswank31 ,

 

Try to modify your formula like below, it can get correct total result:

 

result1 = 
CALCULATE (
    MAXX (
        KEEPFILTERS ( VALUES ( 'Calendar'[Date] ) ),
        CALCULATE ( SUM ( 'Drill'[Rigs] ) )
    )
)

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.