Forum Discussion
Solved
Sales Amount
Guys, hello!
How can I get the total sales considering the columns? Order Quantity, Unit Price and Unit Price Discount Pct ?
I'm trying to use the following measurement, but the total value is not correct:
Total Vendas = SUMX(Sales,Sales[Order Quantity]*Sales[Unit Price]) - SUMX(Sales,Sales[Order Quantity]*Sales[Unit Price Discount Pct])
Thanks
If your discount % value is something like 5% then you can get the amount like this.
Total Vendas = SUMX(Sales,(Sales[Order Quantity]*Sales[Unit Price]) * (1-Sales[Unit Price Discount Pct]))
2 Replies
- jdbuchanan71
Super User
If your discount % value is something like 5% then you can get the amount like this.
Total Vendas = SUMX(Sales,(Sales[Order Quantity]*Sales[Unit Price]) * (1-Sales[Unit Price Discount Pct])) Worked perfectly. Thank you jdbuchanan71
