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
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ，

 

Correct your measure as below:

 

Measure = CALCULATE(MAX('Schedules'[Current Employees]) * SUMX('Schedules','Schedules'[AverageHours]))

 

And you will see:

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you so much for helping me v-kelly-msft!

 

But I can't seem to use the measure [Current Employees] in a MAX function.

Any other ideas?

 

Best regards,

Queenie Barends