Slicer Set Value

Hi Atat0105,

You will need to use a disconnected table here.

Instead of "hardcoding" the IF in your column to <601 you can pass a slicer value through.

Click "Enter data" and build a table like below/ the measure shown in the formula bar.

Once you do this pass that measure into the calculated column like so:

When you are using disconnected tables you allow yourself to pick what you want to slice on. Connect the tables within Power BI to filter correctly. Once you select a value from that disconnect table it will pass that value into the rest of your functions.

Hope this helps,

Christian