Get the most recent value in a table filtred by date in another table

I have the following tables in SSAS tabular cube:

Dax Get the most recent value in a table filtred by date in another table

I have the following tables in SSAS tabular cube :

Show items with no data is giving expected result

I am using a Live connection to an SSAS tabular model having the following tables :