Forum Discussion
create a range filter using a measure
Anonymous
You can go to Modeling Tab, Click on New Parameter, and enter a value range to select, modify your measure as follows. It will allow you to show only the days that fall greater than or qual to the selected value.New Meaure = IF( [Your Measure] > SELECTEDVALUE(Parameter[Parameter]), [Your Measure], BLANK() )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Anonymous
You can go to Modeling Tab, Click on New Parameter, and enter a value range to select, modify your measure as follows. It will allow you to show only the days that fall greater than or qual to the selected value.
New Meaure =
IF(
[Your Measure] > SELECTEDVALUE(Parameter[Parameter]),
[Your Measure],
BLANK()
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Thank you so much Fowmy. I did not know about "What if parameters".
this has solved my issue 🙂