Forum Discussion
Max Value of Calculated Column
Anonymous ,
You can get this by removing the filters on the table for the particular column.
For ex:
If you want output a Max Value for the month and irrespective of team,
the you might have to use DAX like shown below as a measure. Here the assumption is you are having 3 columns in your visual, Month, Team, Value
MaxValue = CALCULATE(MAX(Table3[Value]), REMOVEFILTERS(Table3[Team]))If you need more precise answer for your team, suggestion is to always share, some sample dummy data that you use as input and the expected output
Regards,
Hi Anonymous - Create a new measure or Power query editor in your Power BI report that calculates the maximum score across the entire team.
In Power query editor too.
first do a group by in power query editor in your table after that find the list.max.
List.Max(Table.Column([Gp], "Runs"))
or using measure:
MaxTeamScore =
CALCULATE(
MAX('Performance Management'[Score]),
REMOVEFILTERS('Performance Management'[Individual])
)Hope this helps.
I have a follow up on the above. In the solutions given, I see a small hick up, but before that some more info
The Employee Performance Management is accessible only to the ind Employee via RLS, Manager can see the complete team that reports to them, Senior Manager can see the complete team.
The above solution for the Senior Manager is showing accurate data as he is able to see the full team, but when the Employee or his manager is seeing the data in service, the Max value is either the EE's max value and not team's plus the manager is able to see max at his team level.
I would like the EE see the Max based similar to what Sr. Manager sees