DAX Help - Additional "If" criteria

[kault]

I have a measure that shows values as red (#efb5b9) if Utilization Rate is over 80% (varLevel2).

How can I update this DAX to also show:

• If utilization rate is between 70% - 80%, then show yellow #f0e199
• If Utilization Rate is less than 70%, then show green #d0ef9e

This is the current measure DAX that shows only the red:

conditonalformatting =

    VAR varLevel2 = ( 80 / 100 )

    VAR varLevel1 = ( 35 / 1000 )

    RETURN

        IF (

            ISINSCOPE ('Projector Deployment Report Current and Planned'[Stage]),

            BLANK (),

            IF (

                ISINSCOPE ('Projector Deployment Report Current and Planned'[Resource])

                    && ([Utilization Rate]) > varLevel2,

                "#efb5b9",

                IF (

                    ISINSCOPE ('Resource Assigned Practice Group'[Role])

                        && ([Utilization Rate]) > varLevel1,

                    "#fffff"

                )

            )

        )

[marcelsmaglhaes · Accepted solution]

Hey @kault ,

You can use the SWITCH function to do that. Like something:

conditonalformatting =

    VAR varLevel2 = ( 80 / 100 )

    VAR varLevel1 = ( 35 / 1000 )

    RETURN
     SWITCH (
                         TRUE(),

           ISINSCOPE ('Projector Deployment Report Current and Planned'[Stage]), BLANK (),

           ISINSCOPE ('Projector Deployment Report Current and Planned'[Resource])   &&

                               ([Utilization Rate]) > varLevel2, "#efb5b9",
           ISINSCOPE ('Projector Deployment Report Current and Planned'[Resource])   &&

                              ( ([Utilization Rate]) > 0.7 && ([Utilization Rate]) < 0.8), "#f0e199",

 ISINSCOPE ('Projector Deployment Report Current and Planned'[Resource])   &&

                              ( ([Utilization Rate]) < 0.7, "#d0ef9e", 
 "#fffff"
)

[kault]

Thank you. This gives me an error message. Do you know what is causing the error?

[marcelsmaglhaes]

Yes, has a parenthesis left over in the last line: Try copying and pasting this part of the code to fix:

...............
 ISINSCOPE ('Projector Deployment Report Current and Planned'[Resource])   &&

                              ([Utilization Rate]) < 0.7, "#d0ef9e",
 "#ffffff"
)

[kault]

THANK YOU!!! I have spent hours trying to figure this out. I appreciate it.