Forum Discussion

tracytran91's avatar
tracytran91
Icon for Helper III rankHelper 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

     

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.