Forum Discussion
Max Value of Column (Calculated)
Hello All - I have a Performance Management table. The Manager updates the Actual numbers in different columns. Based on the updated numbers updated, there is a calculated column in POwer BI that calculates the weightage score for each parameter. We have 15 such calculated columns. One of the requirements is to get the max value against the team. For Eg A's score is 10%, B is 22%, C is 30%, In case the A is selected in filter (The PBI has RLS as well), I would like to see the max value as 30% as that value is highest for the month. I hae used the below DAX = Max_Score = Calculate(Max(Table[Score_Tickets]), removefilters(Table[Employee_Name])) 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
@Thejeswar @rajendraongole1 @shafiz_p - Since you helped me with this solution in the past, tagging you.
2 Replies
- elitesmitpatel
Solution Supplier
1)To ensure that all users see the maximum score across the entire team, even when filtered to a specific employee, you can modify your DAX formula as follows:
Max_Team_Score =
CALCULATE(
MAX(Table[Score_Tickets]),
REMOVEFILTERS(Table[Employee_Name])
)2)If you want to ensure that the calculation respects other filters (e.g., by Manager, Team, Date), you can use:
Max_Team_Score =
CALCULATE(
MAX(Table[Score_Tickets]),
REMOVEFILTERS(Table[Employee_Name]),
ALLEXCEPT(Table, Table[Manager], Table[Date])
)If it Helps , Please do appreciate and Accept it as solution.
- Thank you for reaching out. This unfortunately did not work elitesmitpatel
