Forum Discussion
Power BI Slicer - Dynamic Filtering Based on Selected Car Model Price Range with "Higher" and "Lower
Yes!
This is the measure that i am trying to use. The idea is to return '1' for the vehicles that are in the range and '0' for the vehicles that are not.
If i use the measure for lower and higher in a card, the return is correct. But if i use it on the table that i want to filter, it is considering price of the vehicles in each line (it is not considering by the model that i selected in the slicer:
measure:
IsInRange =
VAR Higher = SELECTEDVALUE('Higher'[HigherValue])
VAR Lower = SELECTEDVALUE('Lower'[LowerValue])
VAR SelectedPrice = [SelectedCarPrice]
VAR MinPrice = SelectedPrice + Lower
VAR MaxPrice = SelectedPrice + Higher
RETURN IF(
'Carros'[Preço] >= MinPrice && 'Carros'[Preço] <= MaxPrice,
1,
0
)
Looks good. If it doesn't work as a filter for the table visual then you would need to check your data model for any side effects.
If you like you can post a sample file with your current project status.