Forum Discussion
Calculate profit for every client individually
Hey PowerBi Community, I have a simple beginners question.
I have a table with 6 columns: client, invoice number, date, quantity, sales price and cost to manufacture (profit is a measure: quantity*sales price-quantity*cost to manufacture). I want to create a measure that displays total profit by client next to each invoice (order), is that possible?
Thanks in advance,
Zenons
Hi Anonymous ,
You may create measure like DAX below .
Profit = VAR _Quatity = CALCULATE ( SUM ( Table1[quantity] ), ALLEXCEPT ( Table1, Table1[client], Table1[invoice number] ) ) RETURN _Quatity * ( MAX ( [sales price] ) - MAX ( [cost to manufacture] ) )Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
Anonymous , Try
new column = [quantity]*([sales price]-[cost])
new measure = sumx(table, [quantity]*([sales price]-[cost]))
amitchandak Both new column and new measure just show profit for every order next to the invoice number, but I want to see the total profit from the client that made the order next to the invoice number.
v-xicaiCommunity Support
Hi Anonymous ,
You may create measure like DAX below .
Profit = VAR _Quatity = CALCULATE ( SUM ( Table1[quantity] ), ALLEXCEPT ( Table1, Table1[client], Table1[invoice number] ) ) RETURN _Quatity * ( MAX ( [sales price] ) - MAX ( [cost to manufacture] ) )Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
