Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure not calculating on each row

Hi guys,   I am trying to calculate the total hours scheduled for each month. To do this I have 1 measure that calculates the amount of active employees, a column with the average hours.   Curren...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

This multiplication need to be done at some context level like Month or employee ID, Based on that use formula like this

Measure = CALCULATE([Current Employees] * SUMX(Schedules; Schedules[AverageHours]), values(date[Month]))
Measure = Sumx(SUMMARIZE(Table, date[Month],"_sum"[Current Employees] * SUMX(Schedules; Schedules[AverageHours])),[_sum])