Using a slicer to calculate a total!

[Anonymous]

I am looking to find out how many hours each employee is working per week.

I have a table with the office hours that each employee has worked per day. I also have a lookup table with the fixed number of hours that each employee works from home each week (this does not change each week).

I have a slicer with number of weeks. When i select one individual week i can see the correct total (the individuals weeks office hours plus there work from home hours). However if i select more than one week i am able to see the correct office hours HOWEVER still only able to see one weeks worth of working from home hours.

FOR EXAMPLE: 

When selecting Week 15 "James" Work from home hours are 7.5 (which is correct)

When selecting Week 16 and 15 "James" Work from home hours are still 7.5 (This is two weeks so should be 7.5 X 2 = 15)

[#2]

I am looking to find out how many hours each employee is working per week.

I have a table with the office hours that each employee has worked per day. I also have a lookup table with the fixed number of hours that each employee works from home each week (this does not change each week).

I have a slicer with number of weeks. When i select one individual week i can see the correct total (the individuals weeks office hours plus there work from home hours). However if i select more than one week i am able to see the correct office hours HOWEVER still only able to see one weeks worth of working from home hours.

FOR EXAMPLE: 

When selecting Week 15 "James" Work from home hours are 7.5 (which is correct)

When selecting Week 16 and 15 "James" Work from home hours are still 7.5 (This is two weeks so should be 7.5 X 2 = 15)

[#3]

When selecting Week 15 "James" Work from home hours are 7.5 (which is correct)

When selecting Week 16 and 15 "James" Work from home hours are still 7.5 (This is two weeks so should be 7.5 X 2 = 15)

[v-yuta-msft]

Hi vickygibbons123,

Have you create some calculate columns or measure to sum the working hours based on values you selected? If not, you can create a measure using DAX like this:

Total working hour =
CALCULATE ( SUM ( table[hours] ), ALLSELECTED ( table[weeks] ) )

Regards,

Jimmy Tao