cancel
Showing results for
Did you mean:
Member

## 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 Team

## 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
Community Support Team

## 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.

Announcements

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### PBI Community Highlights

Check out what's new in the Power BI Community!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 382 members 3,667 guests
Recent signins: