Forum Discussion

dwel0120's avatar
dwel0120
Icon for Helper III rankHelper III
5 years ago
Solved

What 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 ...
  • v-robertq-msft's avatar
    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:

     

    1. Create a calculated column in the main table like this:
    Year count = CALCULATE(DISTINCTCOUNT('Table'[Year]),FILTER(ALL('Table'),[StudentID]=EARLIER('Table'[StudentID])))
    1. Create a What-if parameter and add a slicer to the page:

     

    1. Create a measure:
    Flag =
    
    IF(MAX('Table'[Year count])=[Parameter Value],1,0)
    1. 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.