Filter unsual value with parameter slicer

[tracytran91]

Hi friends, 

I would like to filter values ( created by a measure ) by using a "What-if" parameter. Could you please help me to create a measure to filter values which is greater than the input value?

For example: 

If the user input a value 3.01. The measure [ %discount vs Gross Sale] should ONLY show up value greater than 3.01 

Any help is highly appreciated. 

Thank you in advance. 

onlyand nothing moreMore (Definitions, Synonyms, Translation)

[v-eqin-msft · Accepted solution]

Hi @tracytran91 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.😀

Best Regards,
Eyelyn Qin

[tracytran91]

Thank @v-eqin-msft for the solution!

[v-eqin-msft]

Hi  @tracytran91 ,

You could use the following formula to create a measure

Measure = IF([%discount vs Gross Sale]>=[Parameter Value],1,0)

and apply it to filter pane(set as "=1") as shown below:

Here is the pbix file.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@tracytran91 , Try a measure like

measure =
var _sel = selectedValue(whatif[whatif])
return
avergageX(filter(Values(Table[customer]),[%discount vs Gross Sale]>_sel),[%discount vs Gross Sale])