Hi Avantika-Thakur ,
Thanks very much for your reply.
Your reply works perfectly if there is only one sales order, but I have multiple sales orders so if I use ALL SELECTED the total discounts from all the sales orders are averaged over all the SKUS, whereas I would like to have the discount amount from the specific sales order to be allocated over the sales lines in the corresponding sales order.
I will be using this to calculate the Net Sales and gross margin by SKU, so wont always have the SO Number in the table/graphic if that affects anything.
Is this possible?
I have added another sales order line in the example PBIX file (same link/link below), with the desired result.
Thanks for your time,
Jessie