Obtaining a row value when using "Less than or equal too slicer (Year)

Hi,

I do not know how your data model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your data model.

Value maxyear measure: =
CALCULATE ( [Value total measure:], 'Year'[Year] = MAX ( 'Year'[Year] ) )

Hi,

Thank you for your message, and please check the below picture and the attached pbix file.

Value 2010 measure: = 
CALCULATE ( [Value total measure:], 'Year'[Year] = 2010 )