Dax Measure for Nested Row Contexts

Hi Payeras_BI,
Thankyou so much for the solution.

There is a few things that i want to add up.

Now, I have data based on dates.
And user is free to choose any date(s) from the slicer filter.

Now, the problem is that it is showing the same number no matter which date(s) i pick up.

For example, for boat_id = 2, i have 3 secondary_id entries.
one on 01-01-2023.

remaining two are on 02-01-2023.

But if i select, a date let us say, 01-01-2023, it should ideally show secondary_weight 22 for boat_id = 1.

But it shows the weight for all dates.

like this.

We are missing the date filter. Could you please modify the dax for this?
i need to filter based on dates as well as boat_id.

Thanks again!