Ignore multiple filters in table

Thanks for responding Allison. Agree it is confusing to explain. I have sent you the PBIX file and the equivalent Excel version I am trying to replicate.

For better context: every month we take a snapshot of current year financial forecasts and save them as separate tabs. These “snapshots” contain forecast data for each month/period of the year as separate columns (Period 1, Period 2, Period 3 etc).

Each snapshot also includes a single Budget column.

My data model appends all of the snapshot data into one table and then unpivots them. There is a column which identifies which snapshot each row is sourced from (e.g. snapshot 1, 2, 3).

A user can use a slicer to filter by snapshot (e.g. snapshot 12).

In my unpivoted table, for each period/attribute row (Period 1, Period 2, Period 3 etc), I want to create a Budget column which returns the Budget column from the equivalent snapshot number. So for Period 1 row, return the Budget column in snapshot 1, for Period 2 row, return the Budget column in snapshot 2 etc.

I have attempted the below measure to ignore the period slicer but got stuck. Essentially the measure is trying to use the Sort Column as a helper column to help the measure identify which Sheet Number to reference the Budget column from.

Current Authority = CALCULATE(

SUM('Programme Financials Unpivot'[Value]),

FILTER(

            ALL('Programme Financials Unpivot'),

            'Programme Financials Unpivot'[Sheet Number (Period)] = 'Programme Financials Unpivot'[Sort Column] && 'Programme Financials Unpivot'[Project No.] = [Selected Project]  && 'Programme Financials Unpivot'[Attribute] = "Current Authority"

            ))

I hope this makes sense?