Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Cumulative Subtotals

Spoiler
 

Dear All,

 

Is it possible to create a measure, in which the row subtotals are cumulative? Just like my example:

 

Group     Value

Grp1          3

Grp1          4

Grp1 Subtotal:  7

Grp2          2

Grp2 Subtotal:   9

 

So, I'd like to add the values in the 2nd group to the 1st row subtotal value!

 

Thank You in advance for your help!

Mate Kiss

Need Help

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi @kissmate,

     

    If I understand your requirement correctly, assuming that you have the data below.

    e

    And you create the matrix visual below and you want to get the Total in red is 175 ?

     

    f

     

    If it is not your case, please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Dear Dale, v-jiascu-msft

       

      yes you're right!! I'd like to get the 175 in your example, in red, instead of the 115. (So it's 60+115 in the red and not in the column total).

      Is it possible to do the same?

      Best Regards,

       

      Máté 

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        8 years ago

        Hi Anonymous,

         

        It may impossible for you to get your desired output.

         

        You could try to refer to the measure below.

         

         

        Measure =
        CALCULATE (
            SUM ( 'Table'[Sales] ),
            FILTER (
                ALL ( 'Table' ),
                'Table'[Group] <= MAX ( 'Table'[Group] )
                    && 'Table'[Project] <= MAX ( 'Table'[Project] )
            )
        )

         

        And the output is below.

         

         

         

        If you need additional help, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

         

        Best Regards,

        Cherry