Forum Discussion

Vanessa250919's avatar
Vanessa250919
Icon for Helper V rankHelper V
2 years ago
Solved

Max in measure

Hello All, I have 6 measures in DAX, and I'm trying to write a measure that will show which of the measures below has the highest result. In the measures, there are numbers. Here are the 6 measures...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi

     

    Try using the dax below to get the maximum value for each row

     

    MaxValue11 = 
MAXX(
    UNION(
        SUMMARIZE('Table', "Value", 'Table'[Green]),
        SUMMARIZE('Table', "Value", 'Table'[Grey]),
        SUMMARIZE('Table', "Value", 'Table'[Orange])
    ),
    [Value]
)

     

    This is the result you want

     

     

    Since there is no function in DAX that can be used to get the column names in a table, it is not possible to use DAX to change the color of a value based on the column where the maximum value is located.

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi

 

Try using the dax below to get the maximum value for each row

 

MaxValue11 = 
MAXX(
    UNION(
        SUMMARIZE('Table', "Value", 'Table'[Green]),
        SUMMARIZE('Table', "Value", 'Table'[Grey]),
        SUMMARIZE('Table', "Value", 'Table'[Orange])
    ),
    [Value]
)

 

This is the result you want

 

 

Since there is no function in DAX that can be used to get the column names in a table, it is not possible to use DAX to change the color of a value based on the column where the maximum value is located.

 

 

 

 

 

 

Best Regards,

Jayleny

 

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