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.

lbendlin's avatar
lbendlin
Super User
2 years ago

That formula seems a little off. What's the point of the MAXX ? You want to find the number of rigs for the maximum date in your filter context?