How to sum the remainder of a subtraction from a measure to the next row of a different measure?

[ftmanoel]

Hello everyone,

I'm trying to achieve the following (even though I'm not sure it's achievable):

I have a matrix with a few columns. All of the values in the matrix are measures, only the year column is an actual column. Everything else are measures.

The last column "To execute" is calculated by subtracting ("Grand total" - "Executed"). If there is a positive value in this column, I need to add it to the next year's grand total. In this case, the grand total for 2024 would be the initial 300 + the remaining 150 from the last column.

Considering this table is entirely made of measures and not calculated columns, and therefore I don't have row indeces, is this possible? 

Extra info, in case it is relevant:

• The year column comes from a calendar table that is related to all the tables I need to calculate my measures (3 different tables);
• This is probably irrelevant but, in case anyone is wondering, I am using a matrix instead of a table because I was requested to present the totals row in the first row instead of last, and I could only make that happen was with a matrix (as far as I know). 

Thank you in advance to anyone who might take the time to analyze this.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[lbendlin]

you should avoid computing with nested measures. Instead, apply the entire business logic in its own measure.

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523