Line Chart w/ 3 Lines & Measure

[Xx_LAMORAK_xX]

I am trying to figure out the way to add a line chart visual with two y axis.  I need to show packages recieved and packages delivered on one axis and then on the second axis I want to show a comparison between the two using the following; [(Packages Received - Packages Delivered)/Packages Delivered].  I can get the first part of this pretty easily with a standard line chart, but I am having a difficult time creating the measure for the last part and placing it on its own axis.  Below is a sample from my data.  Thank you so much for your help!

Facility	Packages	Receipt/Delivery	Month
Redbud	11001	R	Jan-20
Redbud	12103	D	Jan-20
Redbud	12000	R	Feb-20
Redbud	11542	D	Feb-20
Redbud	10500	R	Mar-20
Redbud	10123	D	Mar-20
Redbud	9998	R	Apr-20
Redbud	11756	D	Apr-20
Redbud	11010	R	May-20
Redbud	12102	D	May-20
Redbud	10687	R	Jun-20
Redbud	11253	D	Jun-20
Redbud	9998	R	Jul-20
Redbud	11532	D	Jul-20
Redbud	12002	R	Aug-20
Redbud	12102	D	Aug-20
Redbud	12000	R	Sep-20
Redbud	10123	D	Sep-20
Redbud	10002	R	Oct-20
Redbud	9998	D	Oct-20
Redbud	12001	R	Nov-20
Redbud	11521	D	Nov-20
Redbud	12000	R	Dec-20
Redbud	13250	D	Dec-20

[parry2k]

@Xx_LAMORAK_xX are you looking for something like this.   Would appreciate Kudos 🙂 if my solution helped.

[Xx_LAMORAK_xX]

Thats exactly what I am lookign for!  How did you create that visual and what was the measure you used.  Thanks so much that was quick!

[parry2k · Accepted solution]

@Xx_LAMORAK_xX add following 3 measure and on line chart add measures to the pane as shown below

Packages Received = CALCULATE ( [Sum], Line[Receipt/Delivery] = "R" )

Packages Delivered = CALCULATE ( [Sum], Line[Receipt/Delivery] = "D" )

% Delivered = DIVIDE( [Packages Received] - [Packages Delivered], [Packages Delivered] )

Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com

[Xx_LAMORAK_xX]

This worked like a charm, why didn't I think to parse it out into three seperate measures.  That would have made it super simple!