Forum Discussion

Post Prodigy

6 years ago

Solved

undefined

I have three different KPI's for each of the Priority levels. How can I set different conditional formatting for the results in a table. See screen shots below. This is how I would like it to show...

Need Help

Icey

6 years ago

Hi jcastr02 ,

Please change your condition measure like so:

Condition =
IF (
    MAX ( 'Table (3)'[Priority] ) = "Minor",
    IF ( AVERAGE ( 'Table (3)'[Value] ) > 170, 1, 0 ),
    IF (
        MAX ( 'Table (3)'[Priority] ) = "Major",
        IF ( AVERAGE ( 'Table (3)'[Value] ) > 72, 1, 0 ),
        IF (
            MAX ( 'Table (3)'[Priority] ) = "Critical",
            IF ( AVERAGE ( 'Table (3)'[Value] ) > 24, 1, 0 )
        )
    )
)

This is because of your "average" value in matrix.

Best Regards,

Icey

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

Icey

Community Support

6 years ago

Hi jcastr02 ,

Please change your condition measure like so:

Condition =
IF (
    MAX ( 'Table (3)'[Priority] ) = "Minor",
    IF ( AVERAGE ( 'Table (3)'[Value] ) > 170, 1, 0 ),
    IF (
        MAX ( 'Table (3)'[Priority] ) = "Major",
        IF ( AVERAGE ( 'Table (3)'[Value] ) > 72, 1, 0 ),
        IF (
            MAX ( 'Table (3)'[Priority] ) = "Critical",
            IF ( AVERAGE ( 'Table (3)'[Value] ) > 24, 1, 0 )
        )
    )
)

This is because of your "average" value in matrix.

Best Regards,

Icey

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

jcastr02

Post Prodigy

6 years ago

Thank you Icey this worked!