DAX calculation for Potential sales with table relationships

[VinnieB]

Hi all,

I am trying to get the potential sales measure as in the difference beetween sales order amount and sales invoice amount however I seem to have an issue with the table relationships.

Below is my dax code and image of the tables relationships

Potential Sales = 
CALCULATE (
    SUMX (
        SalesOrderLines,
        SalesOrderLines[Order Amount]
            - CALCULATE (
                SUMX ( RELATEDTABLE ( SalesInvoiceV2Lines ), SalesInvoiceV2Lines[Sales Amount] ),
                FILTER (
                    SalesOrderLines,
                    SalesOrderLines[SalesOrderNumber] = SalesInvoiceV2Lines[SalesOrderNumber]
                )
            )
    )
)

The code will not allow me to filter by the SalesOrderNumber from the invoicelines table. Any recommedations on the best way to do this or have I got it all wrong? Any assistance would be great.

[amitchandak]

@VinnieB ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.