Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kelly008
Helper I
Helper I

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:

kelly008_0-1667820406622.png

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!



1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.