Descending Running Total Issue with Relationship

Hi Everyone,

My Goal here is to make a bar chart about Descendent Running Total.

We want to calculate how much amount of the remaining balance for each period.

Please note that I have two sets of data, and I joined them (both ways) by “Number.” (1 to N)

The final chart should like this. 

Like a general running total, I can make a measure like this.

Actual running total in Actual =

CALCULATE(

                SUM('Finance'[Forecast]),

                FILTER(

                                ALLSELECTED('Finance'[Period]),

                                ISONORAFTER('Finance'[Period], MIN('Finance'[Period]), ASC)

                )

)

The chart looks perfect at the beginning. However, When I put in a Slicer of “Name”, which is from Table links to Info Table (top table), the chart went crazy and looks like this.

Seems like the problem is that the measure now includes ALL periods. However, if I select #1, I just want to see #1’s period instead of ALL other periods.

(Note: the filter works fine if the slicer field comes from the same table. But it doesn't work with a linked table) 

Does anyone know how to fix this issue?

Thank you so much for your help!

Thank you,

Matthew