create a range filter using a measure

[Anonymous]

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 a matrix that shows the category and the number of business days that the most recent sale was made of an item from that category.  It looks somenthing like this:

category:                  food / clothes / x / y / z

days since last sale:   36  /       4    / 3 / 7 / 87     

I would like to create a range filter in order to filter the "days since last sale".

So for example if the filter is >10 then i would only see the categories "food" and "z".

I have seen that I can not use a measure to create a slicer so how can this be worked-around? 

[amitchandak]

@Anonymous , 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

[Fowmy · Accepted solution]

@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 🙂

YouTube  LinkedIn

[Anonymous]

Thank you so much Fowmy. I did not know about "What if parameters".
this has solved my issue 🙂