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 ,

I have no access to your shared file.

Best Regards,

Icey

jcastr02

Post Prodigy

6 years ago

Sorry it looks like it wont let me share, attached is screen shot where I show average of the turn around time, and the rules set , along with DAX. Icey

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!