Filter Measure based on Text Value in Measure

Click here to download solution 

How is works ...
Create a option pick list table and add a single selection slicer

Create a measure that returns 1 when the output matches the slicer option

IsOption = 
VAR selectedoption = SELECTEDVALUE('Option picklist'[Option])
RETURN
SWITCH(TRUE(),
    selectedoption = "All Margins",1,
    selectedoption = "Positive Margins" && [Margin%] >= 0,1,
    selectedoption = "Negative Margins" && [Margin%] < 0,1
)

Add a filter must = 1 to your repport visual

Remember we are unpaid volunteers. So please click the thumbs up and the [accept as solution] button to leave kudos. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

If you quote speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

Please now click the thumbs up and the [accept as solution] button.  Thnak you.