Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I am currently trying to get the absolute percentage difference between 2 time values, but I'm struggling to get it to work.
I have this table:
I need the following calculation: Run_Time/SFI_Total_Posted_Run_Time x 100
However the calculation I use doesnt work:
Solved! Go to Solution.
@kelly008 , you have to create a measure like
Divide(
SUM(RoutingLinesNew[Run_Time]),
SUM(routinglinesnew[sfi_total_posted_run_time]))
and mark that as % column
Please remember the two are not equal
Run_Time/SFI_Total_Posted_Run_Time <>
Divide(
SUM(RoutingLinesNew[Run_Time]),
SUM(routinglinesnew[sfi_total_posted_run_time]))
@kelly008 , you have to create a measure like
Divide(
SUM(RoutingLinesNew[Run_Time]),
SUM(routinglinesnew[sfi_total_posted_run_time]))
and mark that as % column
Please remember the two are not equal
Run_Time/SFI_Total_Posted_Run_Time <>
Divide(
SUM(RoutingLinesNew[Run_Time]),
SUM(routinglinesnew[sfi_total_posted_run_time]))
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |