Forum Discussion

ManuelGeiger's avatar
ManuelGeiger
Icon for Helper I rankHelper I
3 years ago
Solved

DAX to summarize multiple ratings

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 ma...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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:

     

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

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: