Forum Discussion

zraopingm's avatar
zraopingm
Helper IV
1 year ago
Solved

CALCULATION GROUP TOTAL DOES NOT TOTAL RIGHT

Hello Friends,  Ref: Calculation group  I followed learn instructions and created below 3 calculation items image 1 and used them in the report.. the line items are correct, but the totals see ima...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    I tried to create a sample pbix file like below, and please check the below picture and the attached pbix file.

     

     

     

     

     

     

    Current = SELECTEDMEASURE()

     

    Previous_Month = 
SUMX (
    VALUES ( 'calendar'[Year-Month] ),
    CALCULATE ( SELECTEDMEASURE (), PREVIOUSMONTH ( 'calendar'[Date] ) )
)

     

    Month_Change = 
SELECTEDMEASURE ()
    - SUMX (
        VALUES ( 'calendar'[Year-Month] ),
        CALCULATE ( SELECTEDMEASURE (), PREVIOUSMONTH ( 'calendar'[Date] ) )
    )

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
1 year ago

Hi,

I tried to create a sample pbix file like below, and please check the below picture and the attached pbix file.

 

 

 

 

 

 

Current = SELECTEDMEASURE()

 

Previous_Month = 
SUMX (
    VALUES ( 'calendar'[Year-Month] ),
    CALCULATE ( SELECTEDMEASURE (), PREVIOUSMONTH ( 'calendar'[Date] ) )
)

 

Month_Change = 
SELECTEDMEASURE ()
    - SUMX (
        VALUES ( 'calendar'[Year-Month] ),
        CALCULATE ( SELECTEDMEASURE (), PREVIOUSMONTH ( 'calendar'[Date] ) )
    )

 

zraopingm's avatar
zraopingm
Helper IV
1 year ago

Thank you!!! it works!

Question: I tried to turn off subtotal from calculating items "current" and "previous mth" and only want to leave mth_change item with the total on.. 

I can understand why but at the same time, it is not super flexible. 

thank you for your time 

Zoey