cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dpombal Member
Member

Sum of values in a measure with divide measure

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)

 

1.PNGs

 

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

 

2.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Sum of values in a measure with divide measure

@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]
)
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.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: Sum of values in a measure with divide measure

@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]
)
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.

Helpful resources

Announcements
Virtual Launch Event

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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 382 members 3,667 guests
Please welcome our newest community members: