Comparing column values to a measure to create new filtered table

[jhuaco]

Hello! 

I'm a Power BI newby, so bear with me, or let me know if Ia not providing enough details. 

I have a table with enrollment records called 'Students' (for multiple years) , and a table  'Applications' (with all apllications for multiple years)

I have created a report where I want to show the applications funnel for a specific year. I am using a slicer to filter the students enrolled ('Students'[Year]). Ideally that same slicer would filter the column StartTerm in the Applications table, but I can't get that to work. 

So I tried something different. I created a measure to store the value selected in the slicer: SelectedYear = SELECTEDVALUE('Students[Year]), hoping that I can then use it to compare the StartTerm value in the Applications table and return a filtered table with all the relevant rows, but it doesn't seem to be working.

Here's what I have for the filtered table:

ApplicantListSelectedYear = FILTER('Applications','Applications'[Year] = 'Students'[SelectedYear] ). I don't get any errors, but the filtered table still shows applications for all the years instead of just the filtered ones. 

I sohuld add that when I use a statis text in quotes, it works just fine: For example, 

ApplicantListSelectedYear = FILTER('Applications','Applications'[Year] = "2020FA" )

This returns the filterd table with only applicants who wish to start in Fall 2020. 

I also have verified that the measure is storing the selected value correctly. 

What am I doing wrong? Or is there another way to do this altogether?

Thanks!

[amitchandak]

@jhuaco . a calculated table can not use slicer value

You can get slicer value in filter of measure like

Countrows(FILTER('Applications','Applications'[Year] = max('Students'[SelectedYear] )))

Countrows(FILTER('Applications','Applications'[Year] = selectedvalue('Students'[SelectedYear] )))

or

measure =

var _max = maxx(allselected('Students','Students'[SelectedYear])

return

Countrows(FILTER('Applications','Applications'[Year] = _max )))