Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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, can you help me?
Green NB
Grey NB
Orange NB
Yellow NB
Red NB
High Red NB
Solved! Go to Solution.
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.
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.
I need to have an other column : If the max number is Green, I need to see Green
User | Count |
---|---|
51 | |
34 | |
19 | |
15 | |
14 |
User | Count |
---|---|
94 | |
80 | |
37 | |
22 | |
18 |