Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to 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
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
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.
@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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |