cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dpombal
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
v-chuncz-msft
Community Support
Community Support

@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
v-chuncz-msft
Community Support
Community Support

@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

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
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.