Cannot relate tables

Hi,

In the attached PBI file, create a single column table of all unique products from Dollar and Qty tables.  Create a Many to One relationship from Dollar and Qty tables to this new product table.  To your visual, drag Product from the new table.

Hope this helps.

Hi Oros ,

I updated your sample pbix file(see the attachment), please find the details in it.

1. Delete the relationship between tables

2. Create a calculated column as below

Column = 
VAR _invoiceqty =
    CALCULATE (
        SUM ( 'INVOICE QTY'[QTY INVOICED] ),
        FILTER ( 'INVOICE QTY', 'INVOICE QTY'[PRODUCT] = 'SALES TABLE'[PRODUCT] )
    )
VAR _maxpdate =
    CALCULATE (
        MAX ( 'CREDIT QTY'[POSTING DATE] ),
        FILTER ( 'CREDIT QTY', 'CREDIT QTY'[PRODUCT] = 'SALES TABLE'[PRODUCT] )
    )
VAR _creditqty =
    CALCULATE (
        SUM ( 'CREDIT QTY'[QTY CREDITED] ),
        FILTER ( 'CREDIT QTY', 'CREDIT QTY'[PRODUCT] = 'SALES TABLE'[PRODUCT] )
    )
RETURN
    IF (
        ISBLANK ( _creditqty ),
        BLANK (),
        IF ( 'SALES TABLE'[POSTING DATE] = _maxpdate, _invoiceqty + _creditqty )
    )

Best Regards