Aggregation based on group by/ summarization and filter.

Hi ,

If you have a problem with the data type, try changing the date type to date.

For the condition that the year to be equals to year of selected date, creating the new measure to filter the values.

Measure = 
var _year = SELECTEDVALUE('Date'[MonthYear])
RETURN
IF(YEAR(_year) = SELECTEDVALUE(Data[Year]), 1, 0)

Drag the measure to the table visual Filters pane and set show item is 1.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.