Forum Discussion

nidhs909's avatar
nidhs909
Frequent Visitor
2 years ago

Total on measure column

Hello There, 

 

I have a table below with the last column calculated using a measure. If i add a total row, it doesn't add total for the measure column. Please help to resolve the issue. 

 

Thank you in advance.

Need Help

3 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    2 years ago

    Hi nidhs909 -you can modify your measure to handle the total row explicitly by using the ISINSCOPE() or HASONEVALUE() functions.

     

    Replace with your table name and column in below formaule and check it. 

     

    I have used quantity column in my table and matl is my table name replace it with your model.

     

    TotalMeasure =
    IF(
        ISINSCOPE('Matl'[Quantity]),
        [Total Quantity],  -- This will calculate for individual rows
        SUMX(
            'matl',
            [Total Quantity]  -- This will calculate the total for the table
        )
    )

     

     

    Still issue exist, share the sample data in excel copy and paste it . will check 

     

    Hope this works.

     

    • nidhs909's avatar
      nidhs909
      Frequent Visitor
      2 years ago

      Thank you for the prompt response. 

       

      This is the measure calculation for the column 'BonusAmt', which has multiple columns involved. 

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi,

        Thanks for the solution rajendraongole1 offered and i want to offer some more information for user to refer to.

        hello nidhs909 , based on your description, you can create the following measure.

        Measure =
SUMX ( VALUES ( MergedRows[Grade] ), [BonusAmt] )

        Best Regards!

        Yolo Zhu

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