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 cal...
elitesmitpatel
Solution Supplier
Solution Supplier1)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