Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a measure called [Staff Performance] which is simply DIVIDE([Measure A], [Measure B])
On a matrix visual, this [Staff Performance] measure displays correctly = at daily and weekly levels.
The matrix has a drill-down hierarchy of Manager -> Staff -> Week -> Day. When the data displays at Manager level, I would like the a measure that will be the MAX([Staff Performance]) across all of the staff under the manager.
But when I try this measure
Best Staff Performance := MAX([Staff Performance])
I receive an error: The MAX function only accepts a column reference as an argument.
How can I write a measure to do this?
Solved! Go to Solution.
You can use this approach with MAXX(). This should give you the max employee for each Manager, and the overall MAXX in the "Total".
Max Employee Value = MAXX(VALUES(Table[Employee]), [Staff Performance])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Anonymous ,
something like this
Best Staff Performance = calculate(MAX([Staff Performance]), allexpect(Table[Manager]))
in case you need to build hierarchy using the path , refer -https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
You can use this approach with MAXX(). This should give you the max employee for each Manager, and the overall MAXX in the "Total".
Max Employee Value = MAXX(VALUES(Table[Employee]), [Staff Performance])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |