Numeric-Slicer Count

Hi Rene83 

I created a sample. Filter the numbers in the data table through the number category in the slicer, and you can see if it meets your needs.

(1)Create a slicer table with number category .

(2)Then create a measure to judge whether the data in data table match the selected value in slicer .

Flag =
VAR _sum =
    CALCULATE (SUM ( 'Table'[value]), ALLEXCEPT ( 'Table', 'Table'[Product] ))
RETURN
    SWITCH (MAX ( Slicer[category] ),
        "10+", IF ( _sum > 10, 1 ),
        "30+", IF ( _sum > 30, 1 ),
        "50+", IF ( _sum > 50, 1 ),
        "100+", IF ( _sum > 100, 1 ),
        "All", 1)

(3)Add the measure in data visual and set the measure is equal 1

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.