Forum Discussion

joannasokolowsk's avatar
joannasokolowsk
Icon for Helper II rankHelper II
5 years ago
Solved

MAX/MIN measure

Hi all, I need a help with MAX/MIN measure which will be checking the max/min sum of number of hours per person (by category).  For example, based on below datasat the max sum number of hours per p...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    joannasokolowsk , Try one of the two

     

    minx(values(Table[name]), calculate(sum(Table[length in hours])))

    or
    minx(Summarize(Table,Table[category],Table[name]"_1", calculate(sum(Table[length in hours]))),[_1])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

joannasokolowsk , You can try measure like these

 

minx(values(Table[category]), calculate(sum(Table[length in hours])))

 

maxx(values(Table[category]), calculate(sum(Table[length in hours])))

 

For top Min or Max, you can use Rank or TOPN

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

TOPN https://www.youtube.com/watch?v=QIVEFp-QiOk
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415