Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |