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