Value of the last date that not is blank

Hi,

I have a data source similar to the example, with different indicators, different dates and the value of the indicador for each date.

I want to get the last value of the year, when the value is not 0.

If I use "calculate(lastdate([date]),not([value])=0)", I get "30/06/2020". But, when I try it with "lastnonblank" I get 43,50 for the Id 0.2 instead of 40,00.

The goal is show in a table the last value for the year (according to dates) when it is not 0, and If I filter for each quarter obtein the value for this date. In this case, I want to get for the year 2020 the value 79,80 for Id 0.1 and 40,00 for Id 0.2.

Could you help me to solve this dax expression?

Thanks,