Forum Discussion
dwel0120
Helper III
5 years agoWhat if Parameter returning specific values
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 ...
- 5 years ago
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:
- Create a calculated column in the main table like this:
Year count = CALCULATE(DISTINCTCOUNT('Table'[Year]),FILTER(ALL('Table'),[StudentID]=EARLIER('Table'[StudentID])))- Create a What-if parameter and add a slicer to the page:
- Create a measure:
Flag = IF(MAX('Table'[Year count])=[Parameter Value],1,0)- 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
Super User
5 years agodwel0120 ,
Measure =
var _1 = distinctcount(Table[year])
Var _2 = countx(filter(values(Table[Student]), _1 = selectedvalue(whatif[parameter])),[Student])
return
_2
- dwel01205 years ago
Helper III