Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
s
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
Solved! Go to Solution.
You may add an additonal measure as shown below.
Measure = SUMX ( SUMMARIZE ( Working, Working[employee], Working[Date], Working[bank_Id] ), [hours_by_employee_date] )
You may add an additonal measure as shown below.
Measure = SUMX ( SUMMARIZE ( Working, Working[employee], Working[Date], Working[bank_Id] ), [hours_by_employee_date] )
Dear v-chuncz-msft
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |