Return a single value from a column based on a measure

[rmeng]

Is it possible to extract a value from a column based on the following measure?

I want a scalar value from Year column (2020 as an example) based on a measure.

CALCULATE( VALUES('CALENDAR'[Year]),FILTER(Interactions [# Interactions] = 7931))

[rmeng]

[Anonymous]

This #interaction is a measure or field from your data??? 

[rmeng]

It´s a measure not a calculated column

[Anonymous · Accepted solution]

Measure 1 =

VAR summary =

ADDCOLUMNS (

SUMMARIZE (

'Table',

'Table'[Year]

),

"temp", #Interactions

)

RETURN

MINX (

FILTER (

summary,

[temp] =7931

),

'Table'[Year]

)


This will work fine, just edit you table column

[Anonymous]

You can try below measure:
=

CALCULATE(FIRSTNONBLANK('CALENDAR'[Year],1),Interactions [# Interactions] = 7931)