I wanna select the value of salary from specific year, now I have "YEARS" column and "Salary" column

[zehaoniu]

So how could I make it in measure?

[V-lianl-msft · Accepted solution]

Hi @zehaoniu ,

Please try DAX like below:

Measure = CALCULATE(SUM('Table'[salary]),'Table'[year]=SELECTEDVALUE('Table 2'[year]))

You could see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 

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

[Anonymous]

put in the slicer your "Year" field.

Create a new measure: 

Measure = 
VAR _year= CALCULATE(MAX(Your_Table[Year]))
RETURN CALCULATE(MAX(Your_Table[Salary]), FILTER(Your_Table, Your_Table[Year] = _year))