DAX conditional formattiong help

[aspitalnick]

What am I doing wrong

CLS_cond_form = VAR BM_ =SELECTEDVALUE('Acadiance 1-6'[Benchmark])

        VAR Grade_ = SELECTEDVALUE('Acadiance 1-6'[Grade])

        VAR CLS_ = SELECTEDVALUE('Acadiance 1-6'[NWF-CLS])

Return

SWITCH

    (True(),

        Grade_ = "1" && BM_ = "BM1" && CLS_ <30, "100",

        Grade_ = "1" && BM_ = "BM1" && CLS_ <= 1000, "102",

    Grade_ = "2" && BM_ = "BM1" && CLS_ <40, "103",

    Grade_ = "2" && BM_ = "BM1" && CLS_ >60, "104",

    Grade_ = "4" && BM_ = "BM2" && CLS_ <20, "106",

    Grade_ = "4" && BM_ = "BM2" && CLS_ >40, "107",

    BLANK()

)

[PijushRoy]

Hi @aspitalnick 

Is Grade text field or number field
You care using Grade as Text field Grade = "1"

CLS_cond_form = VAR BM_ =SELECTEDVALUE('Acadiance 1-6'[Benchmark])
        VAR Grade_ = SELECTEDVALUE('Acadiance 1-6'[Grade])
        VAR CLS_ = SELECTEDVALUE('Acadiance 1-6'[NWF-CLS])

Return
SWITCH
    (True(),
        Grade_ = 1 && BM_ = "BM1" && CLS_ <30, "100",
        Grade_ = 1 && BM_ = "BM1" && CLS_ <= 1000, "102",
    Grade_ = 2 && BM_ = "BM1" && CLS_ <40, "103",
    Grade_ = 2 && BM_ = "BM1" && CLS_ >60, "104",
    Grade_ = 4 && BM_ = "BM2" && CLS_ <20, "106",
    Grade_ = 4 && BM_ = "BM2" && CLS_ >40, "107",
    BLANK()
)

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[aspitalnick]

Grade is text