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 ,

 

Sorry for the late reply,but the sample data has been removed,can you update it?

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-kelly-msft 

 

It should be back online now.

 

Csv file 

 

Best Regards,

Queenie

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ，

     

    Can you advise me what is in [AverageHours]?Is it a measure?I cant reappear the table you showed in the oringinal post,can you share me your .pbix file if it's not confidential?

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-kelly-msft ,

       

      I cant share the original pbix since it has employee information in it.

      Average hours is the hours an employee should work in a week (like 40 hours or 32).

      I updated the csv to show the average hours since hours does nothing more than show 40.

       

      Best Regards,

      Queenie