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])

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 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...

 

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    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])

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

      Perfect! it works!!! 

       

      Have a great day!