cancel
Showing results for
Did you mean:
Highlighted
Post Patron

## Sum of values in a measure with divide measure

Given Below Table  Working table , i create following measures:

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_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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support

## Re: Sum of values in a measure with divide measure

```Measure =
SUMX (
SUMMARIZE ( Working, Working[employee], Working[Date], Working[bank_Id] ),
[hours_by_employee_date]
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
Community Support

## Re: Sum of values in a measure with divide measure

```Measure =
SUMX (
SUMMARIZE ( Working, Working[employee], Working[Date], Working[bank_Id] ),
[hours_by_employee_date]
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

## Re: Sum of values in a measure with divide measure

Dear

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.

Announcements

#### Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021