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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sandeepk66
Advocate I
Advocate I

percentage of Total for Delay/Ontime

 Data:
Item#  Delay       Ontime   Total   percentage of Total Ontime
1           20           50           120      70/50   =2.4%
2            50          50           100        100/50   =2%
I wanted to create DAX firmula for Delay vs Ontime as percentage of Total
 
I am deriving information for Delaycount and Ontime count: (With Below formula)
Delay/Ontime= IF(TABLE[ReceivedDate]>TABLE[schduledDate],"Delay","On Time")
 
and I need a condition like if Late/Ontime<>0, then percentage of Total for Delaycount vs Ontime count.
 
Treid this but not working
percentage of Total= if ([Delay/Ontime]="On Time",Count([On-Time])/Count([Delay]),'')
 
Need help on getting percentage of Total.
3 REPLIES 3
dilumd
Solution Supplier
Solution Supplier

Above information is not very clear, if you want to see the % of delay, it should be something like this?

 

Item#  Delay       Ontime   Total   percentage of Total Ontime

1           20           50           70      50/70   =71.4%

2            50          50           100        50/100   =50%

 

tell me whether you’re looking for something like this?

that's Right 71.42% 50.0%
Ashish_Mathur
Super User
Super User

Hi,

 

Your question is not clear.  Share the data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.