Conditional formatting with multiple filtering option

Hi MiriamMattar , please try the following measures, don't forget to modify the amount data in IF statements.

Sum Payment = SUM ( Payments[Payments] )

KPI BG+SG 2 = 
VAR __service = SELECTEDVALUE ( Payments[Service] )
VAR __payment = [Sum Payment]
RETURN
    SWITCH (
        __service,
        "School-fees",
            IF (
                __payment >= 30,
                "#008000",
                IF (
                    __payment >= 20 && __payment < 30,
                    "#ffa500",
                    IF ( __payment < 20, "#ff0003" )
                )
            ),
        "Bus-fees",
            IF (
                __payment >= 300,
                "#008000",
                IF (
                    __payment >= 200 && __payment < 300,
                    "#ffa500",
                    IF ( __payment < 200, "#ff0003" )
                )
            )
    )

Test result:

Best Regards,

Community Support Team _ Jing Zhang

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