Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Max Value of Calculated Column

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...
Need Help
  • Thejeswar's avatar
    Thejeswar
    2 years ago

    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,

  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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.

shafiz_p's avatar
shafiz_p
Super User
2 years ago

Hi Anonymous  Since you have not provided any data structure, I am considering, you have team, score and month. You want to find the maximum score among the team for the month regardless of team selection. You can try this:

MaxScore =
Calculate (
    Max(Table[Score]),
    ALL(Table[Team])
)

For other scenario, please provide sample data.

Hope this helps!
If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz