Looking for a total percentage based on totals

[mberkebile]

I have a power BI table of Late vs. On-time Shipments.  I'd like to calculate the TOTAL OnTime finalPercent which would be the TOTAL OnTime Shipments/(TOTAL Late + OnTime Shipments).  It calculates fine by row, but it will not  do the TOTALS (i.e. 105/134). I can only Sum, Don't Sum(as shown below), Average, etc..  Is there a way to get what I want within this table where "NEED % HERE" is?  There are more complexities with dates and such, but this is the jist of what I'm looking for.  Thanks!

Date	Late Shipments	OnTime Shipments	Late+OnTime Shipments	Final Percentage
6/3/2019	17	31	48	64.58%
6/4/2019	5	33	38	86.84%
6/5/2019	7	41	48	85.42%
TOTAL	29	105	134	NEED % HERE

[v-cherch-msft · Accepted solution]

Hi @mberkebile 

You may create a measure like below.PS:Change 'Data' to your table name.

Percent = SUM(Data[OnTime Shipments])/(SUM(Data[Late Shipments])+SUM(Data[OnTime Shipments]))

Regards,

[mberkebile]

Thank you so much!!  I swear I tried this combination, but I think my brain was foggy and I missed trying this measure!  🙂