Help with actual sales price with multiply saleslines

[Anonymous]

Hi
I need help to get the right sales price. In data listed below i have 4 lines with sales price:

When i want to calculate the total salesamount it gets me this:

As you can see it sum each item so i get the wrong sales price and when i times it with the QTY it will of course give me the wrong salesamount. 

[davehus · Accepted solution]

Hi @Anonymous ,

Try SUMX(Table, Sales Price * Qty)

Did I help you today? Please accept my solution and hit the Kudos button.