DAX to summarize multiple ratings

[ManuelGeiger]

Hi all,

I would like to create a measue to show the overall oil condition of multiple different oil tests.

In the screenshot below you can see different results for multiple components of one maschine (action needed (action), caution, normal (all good)) and I would like to summarize those results to show them in an end result per maschine.

The logic should be this:

All components normal -> result: normal

At least one component caution but rest normal -> result: caution

At least one component action -> result: action

Maybe someone has an idea how to create such measure?

[ManuelGeiger]

Works perfectly fine, thank you!

[FreemanZ · Accepted solution]

Try to create a new with the code below:

Measure =

VAR _min = MIN(TableName[Ranking])

RETURN

IF(

     _min = "Action",

    "Action",

    IF(

         _min = "Caution",

        "Caution",

        "Normal"

      )

)

I tried and it worked like this:

dataset: