Need some help to convert Tableau calculation into Power BI which can be used for color

[kasai16]

Hi All,

I need below tabluea calculated filed to be converted into Power Bi which will be used for color 

IF  ZN([Calculated Parameter]) = 0 THEN "No Qty in Scenario"

ELSEIF  (ZN([Calculated Parameter]) - LOOKUP(ZN([Calculated Parameter]),FIRST())) = 0 THEN "Qty = Comumn value in text from a table"

ELSEIF  (ZN([Calculated Parameter]) - LOOKUP(ZN([Calculated Parameter]),FIRST())) > 0 THEN "Qty > Comumn value in text from a table"

ELSEIF  (ZN([Calculated Parameter]) - LOOKUP(ZN([Calculated Parameter]),FIRST())) < 0 THEN "Qty < Comumn value in text from a table"

Thanks in advance for helping

[aduguid · Accepted solution]

Try this measure 

Color Classification =
VAR CalculatedParameter = [Calculated Parameter]
VAR FirstValue = CALCULATE([Calculated Parameter], FIRSTNONBLANK('Table'[Column], 1))
RETURN
IF (
    ISBLANK(CalculatedParameter) || CalculatedParameter = 0,
    "No Qty in Scenario",
    IF (
        CalculatedParameter = FirstValue,
        "Qty = Column value in text from a table",
        IF (
            CalculatedParameter > FirstValue,
            "Qty > Column value in text from a table",
            "Qty < Column value in text from a table"
        )
    )
)