Forum Discussion

tracytran91's avatar
tracytran91
Helper III
5 years ago
Solved

Filter unsual value with parameter slicer

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 v...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

     

amitchandak's avatar
amitchandak
Super User
5 years ago

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])