cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User IV
Super User IV

Re: percentage of Total for Delay/Ontime

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/
Solution Supplier
Solution Supplier

Re: percentage of Total for Delay/Ontime

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?

Highlighted
Advocate I
Advocate I

Re: percentage of Total for Delay/Ontime

that's Right 71.42% 50.0%

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors