cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

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

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.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

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.

View solution in original post

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.

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

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

Upcoming Events

Experience what’s next for Power BI

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

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors