Forum Discussion
What if Parameter returning specific values
- 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.
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.