Filter visual by measure value

[Anonymous]

I have a matrix with an item in the row and the sales months in the columns. I want to be able to filter the matrix where one of the measures exceeds a certain value. I am indicating the value based on a what-if parameter. How do I filter the visual based on the value of the measure? I have see numerous posts about this, but nothing satisifies my requirement. It seems like this would be a valuable feature to have in powerbi. I know you can put measures in the visual filters, but then the user cannot change this value within the UI.

[MattAllington · Accepted solution]

You can’t slice and dice based on measures. This is by design and I doubt it will change. You need to write your measures so they show, or not, based on the result. Conceptually I guess you could create a whatif parameter containing the values you want someone to filter,  place the parameter measure in your other measure with an if statement. Something like this. 

Whatif from 10% to 100% step in 10%

= var mymeasure = something

var myFilter = [whatif measure]

return if(mymeasure <=myFilter,mymeasure)