Show values greater than selected value from filter

Hi Anonymous ,

Here's my solution.

Create another table with number. You can create the table directly by entering data or by using the DISTINCT() function to create a calculated table.

Create a measure.

Measure = IF(SELECTEDVALUE('Table (2)'[Value])=3&&MAX('Table (1)'[Value]) IN {3,4,5},1)

Add this measure into the table visual, the value column is from the Table (1). Set show items when the value is 1.

When 3 in the slicer is selected. Numbers in the slicer are from the Table (2).

Best Regards,

Stephen Tao

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