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.

bswank31's avatar
bswank31
Helper II
2 years ago

Thanks for looking at my issue. That formula was just what I ended with that gave me almost what I wanted. I want to be able to filter by a Year and it will then give me the max number of rigs for each site for that year selected. Then have the correct sub totals for the programs and the grand total.  I do have another measure for Rig count that gives me almost what I need but it doesn't calculate the Sub totals or Grand total correctly. 

Rig Count = SUMX(FILTER('Drill', ('Drill'[Date])= MAX('Drill'[Date])), [Rigs])