percentage of Total for Delay/Ontime

[sandeepk66]

 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.

[dilumd]

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?

[sandeepk66]

that's Right 71.42% 50.0%

[Ashish_Mathur]

Hi,

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