Percentage difference calculation between two tables

[TaariqHussain]

Hi, I have two tables, one with sales and another with costs, I am using the percentage difference measure to calculate the GP% however the GP% is only pulling through for a few products and not for the majority. I was advised to use the related function but not sure how. please see formula below

GP% =

VAR __BASELINE_VALUE = MIN('StockMaster'[Last cost])

VAR __VALUE_TO_COMPARE = MIN('ItemWiseSales'[itemprice])

RETURN

    IF(

        NOT ISBLANK(__VALUE_TO_COMPARE),

        DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

    )

below is how my visual is appearing.

[amitchandak]

@TaariqHussain , it ItemWiseSales is master table and on the 1 side in 1 -to-many relation between ItemWiseSales and StockMaster

You can create a new column in StockMaster

= related('ItemWiseSales'[itemprice])

or measure

Sumx('StockMaster', 'StockMaster'[Last cost] - related('ItemWiseSales'[itemprice]) )

other ways

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8