Forum Discussion

kelly008's avatar
kelly008
Helper I
3 years ago
Solved

Absolute Percentage Difference

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:

 

PercentDiff = CALCULATE(
SUM(RoutingLinesNew[Run_Time])/
SUM(routinglinesnew[sfi_total_posted_run_time]*100))
 
Any help would be greatly appreciated.
Thanks!



Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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]))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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]))