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 above measure and another value:
Missed Meal OT = min(sum('my data'[Overtime Hours]),[Missed Meal Hrs])
the structure of my data is such that for each [Employee ID] I have multiple rows. then all Employee IDs can be grouped into areas. When I look at my data as a table where each row is an Employee ID - the 2 formulas above calculate correctly. But when I take Employee IDs out of the table, and each row is now an Area - the Missed Meal OT formula does not aggregate at the Employee ID level, and tries to just use the totals of each area, which is not what I want. Any help would be greatly appreciated!