How to filter a table by a measure value

Hi Anonymous 

follow the following steps

Create a calculated table

StockFilter =
DATATABLE(
    "FilterOption", STRING,
    {
        {"= 0"},
        {"> 0"}
    }
)

Create a measure to capture the selected filter

SelectedStockFilter =
SELECTEDVALUE(StockFilter[FilterOption])

Create a new measure to apply the filtering logic

ShowItem =
VAR StockQty = [On stock QTY]
VAR FilterOption = [SelectedStockFilter]
RETURN
SWITCH(
    FilterOption,
    "= 0", IF(StockQty = 0, 1, 0),
    "> 0", IF(StockQty > 0, 1, 0),
    1  // Show all by default
)

now drag and drop this measure to filters and set showitem is 1

create the filter using the filter option column you create from the new calculated table

it should work !