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.
Hi, need some help 😉
I have in column A the total price for a product (product type is in column C).
In column B I see how many of the product I sold.
So for example:
So all the lines are a collection of all the sold items.
Now I wish to know what my price per pcs per product is in a pareto (what is the best item to sell).
I want to have the average off all the lines. Note for example that in the first line an apple cost 2€ and in the last line slightly less. So the prices are not always identical.
How can I do this? 🙂
I created a stacked bar chart to try and create a pareto, but it gives me the result of the SUM of all the apples. In this case 2€ + 1.8€ = 3.8€ in the pareto. But I want to divide this number by the amount of times there are apples in my column C.
I hope my request is clear. It looks very logical in my head 😄
Thanks in advance!
Solved! Go to Solution.
hi, @Anonymous
Try this way as below:
Step1:
Add new column for price for each line
Price = 'Table'[Column A]/'Table'[Column B]
Step2:
Use this formula to add a measure
Measure = CALCULATE(SUM('Table'[Price]))/CALCULATE(COUNTA('Table'[Column C]))
Result:
Best Regards,
Lin
hi, @Anonymous
Try this way as below:
Step1:
Add new column for price for each line
Price = 'Table'[Column A]/'Table'[Column B]
Step2:
Use this formula to add a measure
Measure = CALCULATE(SUM('Table'[Price]))/CALCULATE(COUNTA('Table'[Column C]))
Result:
Best Regards,
Lin
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |