Cumulative Subtotals

[Anonymous]

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

[v-jiascu-msft]

Hi @kissmate,

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

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

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]

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]

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