Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |