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