Forum Discussion

kdunaev's avatar
kdunaev
Regular Visitor
6 years ago

Help with aggregation

Hello! I am new on here - first post!! I have a measure calculated as: Missed Meal Hrs = count('Final Data'[Employee ID])*.5 I am trying to create another measure that would take a min value of the...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
6 years ago

kdunaev ,Can you share sample data and sample output.

  • kdunaev's avatar
    kdunaev
    Regular Visitor
    6 years ago

     

    Division

    		Employee IDMissed Meal HrsOT HoursMissed Meal OT hours
    AA123452.500
    AA123462.500
    AA123472.50.220.22
    AA123482.59.922.5
    AA123492.52.182.18
    AA123502.50.050.05
    BB123512.52.932.5
    BB123522.500
    BB123532.50.60.6
    BB123542.53.752.5
    BB123552.54.822.5
    BB123562.50.150.15

     

     

    Desired outputMissed Meal HrsOT HoursMissed Meal OT hours
    AA total15.0012.374.95
    BB Total15.0012.258.25

     

     

    What I am getting:Missed Meal HrsOT HoursMissed Meal OT hours
    AA total15.0012.3712.37
    BB Total15.0012.2512.25
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi kdunaev ,

       

      You can use the below measures.

       

      Missed Meal OT Hr = CALCULATE(SUM(Table5[Missed Meal OT hours]), ALLEXCEPT(Table5,Table5[Division]))
       
      Missed Meal = CALCULATE(SUM(Table5[Missed Meal Hrs]), ALLEXCEPT(Table5,Table5[Division]))
       
      OT Hourss = CALCULATE(SUM(Table5[OT Hours]), ALLEXCEPT(Table5,Table5[Division]))
       
       
      Regrards,
      Harsh Nathani
       
      Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!