Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
I have a list of store numbers and I want to be able to have a parameter (0,100 intervals of 1) in a dropdown, which will filter a table visual to display only those stores whose store number is at or below the selected parameter value.
When I create a DAX measure, I am having trouble with 'greater than' or 'less than' values. I was trying to use the following and drop this as a visual level filter (where equal to 1), but am having no success.
TestMeasure =
var a = selectedvalue(parameter)
var b = selectedvalue(store[number])
return
if(b<=a,1,0)
@akarasick1, the logic of your measure looks correct to me, and I created a simple model myself using TestMeasure as a visual level filter on a table and it worked fine.
As a check, could you place measures corresponding to variables a & b in TestMeasure, plus TestMeasure itself in the table, to confirm they are returning the values you expect?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 18 | |
| 11 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 25 | |
| 21 | |
| 14 | |
| 12 |