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:

     

     

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

Works perfectly fine, thank you!