Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
We are trying to build a report that shows the corresponding labor charge for each technician that worked on a ticket, based on the technician’s actual time on site, as a percentage of the ticket’s total time.
The percentages and the calculations are working properly when analyzing one ticket but breaks down when selecting more than one ticket. Please see examples below:
CORRECT
CORRECT
INCORRECT
DESIRED RESULT
Measures
Total Actual Time on Site (Hrs.) =
SUM ( SV_Service_Ticket_Dispatch[Arrival to Departure (Hrs.)] )
% Labor of Technician =
SUM ( SV_Service_Ticket_Dispatch[Arrival to Departure (Hrs.)] )
/ CALCULATE (
SUM ( SV_Service_Ticket_Dispatch[Arrival to Departure (Hrs.)] ),
SV_Service_Ticket_Dispatch[Service_ticket_id],
SV_Service_Ticket_Dispatch[Service_Tech_Id],
ALLSELECTED ()
)
$ Labor of Technician =
[% Labor of Technician]
* LOOKUPVALUE (
SV_Service_Ticket[Labor_Charge],
SV_Service_Ticket[Service_Ticket_Id], MAX ( SV_Service_Ticket_Dispatch[Service_Ticket_Id] )
)
Here is a link to the sample report:
I am casual user of the tool and appreciate any help provided with this question.
Thank you,
Solved! Go to Solution.
Calculate % of subtotal and use that.
Refer :https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Calculate % of subtotal and use that.
Refer :https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Hello @amitchandak ,
Thank you so much for your help with this. The artilce pointed me in the right direction and was able to get the desired result.
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |