Sum of values in a measure with divide measure

[dpombal]

Given Below Table  Working table , i create following measures:

contacts = sum(Working[contacts_made])

contacts_by_employee_date=CALCULATE([contacts];ALLEXCEPT(Working;Working[employee];Working[Date]))
perc_contacts_by_employee_by_date=DIVIDE([contacts]; CALCULATE([contacts];ALLEXCEPT(Working;Working[employee];Working[Date])) )

hours_by_employee_date= DIVIDE([perc_contacts_by_employee_by_date]* MAX(Working[worked_seconds]) ; 3600)

s

I create below measures to distribute worked times per day from an employee by contacts

contacts = sum(Working[contacts_made])
contacts_by_employee_date=CALCULATE([contacts];ALLEXCEPT(Working;Working[employee];Working[Date]))
perc_contacts_by_employee_by_date=DIVIDE([contacts];

CALCULATE([contacts];ALLEXCEPT(Working;Working[employee];Working[Date])) )
hours_by_employee_date= DIVIDE([perc_contacts_by_employee_by_date]* MAX(Working[worked_seconds]) ; 3600)

Now  my question is how can I get the sum of all hours_by_employee_date

In below sample I need sum of hours in column hours_by_employee date which is 23.5

Here is below pbix

https://1drv.ms/u/s!Am7buNMZi-gwjG7_JJS6JOHc0Igd

[v-chuncz-msft · Accepted solution]

@dpombal,

You may add an additonal measure as shown below.

Measure =
SUMX (
    SUMMARIZE ( Working, Working[employee], Working[Date], Working[bank_Id] ),
    [hours_by_employee_date]
)

[Anonymous]

Dear v-chuncz-msft

You are so great. I have struggled with my  meassure hole evenig, night and next day. You refer to this case from an other case "Measure Total not correct" , where Parker was so friendly to placed a link to his video with ISFILTRED. But it didn't slove my issue. My case is different. 

I have made a Measure with VAR. With your solution, I sholud just made a measure more takes the columns and my meassure and the all works and reconciled.

THANKS.

I know it's a long text but I'am so gratefull.