Slicer to search values between to columns

[daliux]

Hello. I have Amount From and Amount To columns in my data table. Need the slicer to filter all rows that meet this value. For example, if i have value 1000, need to filter all rows, there 1000 is between values Amount From and Amount To.

[amitchandak · Accepted solution]

@daliux , Take a what if parameter or create independent slicer using a table using generate series

new measure =

var _sel = selectedvalue(whatif[Value]) //or use whatifmeasure

return

calculate(sum(Table[bitdamount]), filter(Table, Table[Amount from] >=_sel && Table[Amount to] <= _sel ))

https://docs.microsoft.com/en-us/power-bi/desktop-what-if