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

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

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.