Forum Discussion
create a range filter using a measure
Hello, I have seen similar topics but none of them solve what I'm looking for. I have created a measure that counts the business days from the most recent sale of an item by item category. I have ...
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 🙂
amitchandak
Super User
Super UserAnonymous , you can not create a slicer on a measure. You need to create an independent bucket table and use that in measure along with group by(Values) in new measures.
Refer my video for that, the link for the file given there - https://youtu.be/CuczXPj0N-k