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

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

    Hey!

    Thank you for a such quick response! I added those measure but the result is not as expected ;/ 

    For example for soft skills category the max should be 27.5 as an "A" person has the highest sum number of hours for this category (person "B" has 11 hours for soft skills so it is smaller). When I apply this measure I see 38.5 which is the sum of total hours...