What if Parameter returning specific values

[dwel0120]

I am creating a what if parameter slider. My goal is to use this slider to only include certain values that have data in that year. For example, if a student has a test score in year 18-19 then they would be included when I select "1" in the what if slicer. If the student does not have a score, then they would be excluded. If a student has a test score for 17-18 and 18-19 then they would be included in the "2" selection of the slicer and so on to four years (if selecting the  4 slicer then they would have data for 15-16 through 18-19 and if they miss a year then they would be excluded). I'm not sure how to build the measure to tie in the what if slicer. 

[v-robertq-msft · Accepted solution]

Hi, @dwel0120 

According to your description and sample data, I can roughly understand your requirement, and I’v also created some test data to make a test, I think you can try my steps:

This is my test data:

1. Create a calculated column in the main table like this:

Year count = CALCULATE(DISTINCTCOUNT('Table'[Year]),FILTER(ALL('Table'),[StudentID]=EARLIER('Table'[StudentID])))

2. Create a What-if parameter and add a slicer to the page:

3. Create a measure:

Flag =

IF(MAX('Table'[Year count])=[Parameter Value],1,0)

4. Create a table chart and place it and apply a visual filter like this:

And you can get what you want.

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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

[amitchandak]

@dwel0120 ,

Measure  =

var _1 = distinctcount(Table[year])

Var _2 = countx(filter(values(Table[Student]), _1 = selectedvalue(whatif[parameter])),[Student])

return

_2

[dwel0120]

@amitchandak I'm not sure that will work with my current data set...