Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
@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.
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.
HI @Anonymous ,
Total Sales = SUM(Table[Sales])
Total Cost = SUM(Table [Cost])
Profit = [Total Sales] - [Total Cost]
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |