Running total in two different tables (but linked)

[andrejmfreitas]

Dear all,

I have two tables with two different measures with Running totals, but I wanted the second table to start the running total left in the first table.

Basically, I'd like to have is that Rolling (Value 2) on 11 would start on 449,79 (356,59 + 93,20).

Having two different tables is a requirement.

You can find a sample of the issue in a PBIX file here: https://github.com/andrejfreitas/pbix/blob/main/Running%20total%20in%202%20tables.pbix

Just click on "Download"

In the real PBIX, the DAX looks like this:

Table 01  (Filtered by New Sprint = n)

Field: Sprint number

DAX (Running total for Previous Sprints):

Rolling capacity (Previous sprint) = CALCULATE (

[Theoretical capacity (Previous Sprint)],

FILTER (

ALLSELECTED ( dim_sprint ),

dim_sprint[SprintInt] <= MAX ( dim_sprint[SprintInt] )

)

)

Table 02  (Filtered by New Sprint = y)

Field: Sprint number

DAX (Running total for Previous Sprints):

Rolling capacity (Current sprint) = CALCULATE (

[Theoretical capacity (Current Sprint)] ,

FILTER (

ALLSELECTED( dim_sprint ),

dim_sprint[SprintInt] <= MAX ( dim_sprint[SprintInt] )

)

)

)

I'd like somehow to have that the starting point of Table 02  (Filtered by New Sprint = y) is the Rolling capacity (Previous sprint) filtered by New Sprint = n

I tried something like that in Table 02  (Filtered by New Sprint = y) but it didn't work:

Rolling capacity (Current sprint) = 

CALCULATE( Rolling capacity (Previous sprint), New Sprint = n)

+

CALCULATE (

[Theoretical capacity (Current Sprint)] ,

FILTER (

ALLSELECTED( dim_sprint ),

dim_sprint[SprintInt] <= MAX ( dim_sprint[SprintInt] )

)

)

)

Any help it'd be would be much appreciated.

Thank you!

[amitchandak]

@andrejmfreitas ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[andrejmfreitas]

Here we go @amitchandak ,

Basically, I'd like to have is that Rolling (Value 2) on 11 would start on 449,79 (356,59 + 93,20).

Having two different tables is a requirement.

You can find the PBIX file here: https://github.com/andrejfreitas/pbix/blob/main/Running%20total%20in%202%20tables.pbix

Just click on "Download"

Thank you for your help in advance.