Sum available hours with a filter Start to Finish

[Anonymous]

Hi, 

I am having a little trouble finding the answer to this DAX. 

I wish to sum the total availaible hours, how would I stop the avalble summing to 16?

Task	Resource	Start	End	Available	Worked
Project 1	Name 1	01/01/2019	01/01/2019	8	4
Project 1	Name 1	01/01/2019	01/01/2019	8	5
Resource Table	Capacity
NAME	8HRS
Date Table	Capacity
Date	8HRS

Regards

Steve

[rocky09]

can you provide more details. It will be helpful, if you provide a sample output you are expecting.

[Anonymous]

I am looking for it a summary line by the resource

Resource	Available	Worked
Name 1	8	9

If the resouce worked mutiple days

Task	Resource	Start	End	Available	Worked
Project 1	Name 1	01/01/2019	01/01/2019	8	8
Project 1	Name 1	01/01/2019	02/01/2019	16	16

it  would sumarize as follows 

Resource	Available	Worked
Name 1	16	24

[Ashish_Mathur · Accepted solution]

Hi,

You may downloaded my PBI file from here.

Hope this helps.

[rocky09]

how did you get 32?

[Anonymous]

my mistake should be 24

[rocky09]

create new table from Modeling tab and then use the below DAX. Please rename the columns as per your data.

summarizetable2 = SUMMARIZE(Table2,Table2[Resource],"Available",MAX(Table2[Available]),"Hours Worked",SUM(Table2[Worked]))

[Anonymous]

Am I able to sum only hours worked from Today? I am filtering out the past. 

"Hours Worked",SUM(Table2[Worked]))