Create Filtered Table Between Two Tables

[Syndicate_Admin]

Hello:

I have the following tables, which are related to each other with a common ID number for both,

I need to show data from a table, filtered data for the year 2024 and 2025 for which I made the table with a filter on the page for 2024 and then a measure for the 2025 data:

To calculate the data for 2025 I made the following measurement: (Seeking to remove the filter from the page and applying a new filter)

assigned 2025 = CALCULATE([Assigned],all('Calendar'[Year]),FILTER('Calendar','Calendar'[Year]=2025))

But the result comes out blank.

If I apply a filter to the page for 2024 and 2025 if it shows me data but they are no longer the same for 2024:

What would be the correct way to calculate the measure for 2025?

As a second option I was thinking of creating a filtered table of the COST MONTHLY table and applying a data filter to it only for the year 2025, but since they are in two different tables I don't know how to do it.

Thanks for the help.

On a board I have fli

[amitchandak]

@Syndicate_Admin , Try like

assigned 2025 = CALCULATE([Assigned],FILTER(all('Calendar'),'Calendar'[Year]=2025))