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.
Hello Power BI Community,
I am trying to calculate the Average Sales Price (ASP) for each material in my database. The database is basically thousands of single purchasing transactions:
I have created a measure (ASP) using two other measures (total sales and total quantity). I can put this measure with account names in a table and it will summarize and show me the Average Sales Price for that material.
I can also do the same thing and add Account Name and my table will now tell me the Average Sales Price for a material by a specific Account Name:
What I want to do is be able to divide the ASP shown in the first table (by material) with the one in the second table (by Account Name) in order to see whether the Account pays higher or lower than the average.
Does anyone have any idea on how to do this? Thank you so much in advance !
Best,
Jorge
Solved! Go to Solution.
Hi @jorge_mejia,
Please create a measure using the similar formulas.
Average=CALCULATE(AVERAGE(Table[Sales Price]),ALLEXCEPT(Table,Table[material]))
I test using my sample table.
Create a measure using the formula using the formula below and get expected result.
Average = CALCULATE(AVERAGE(Table1[value]),ALLEXCEPT(Table1,Table1[Material]))
Best Regards,
Amgelia
Hi @jorge_mejia,
Please create a measure using the similar formulas.
Average=CALCULATE(AVERAGE(Table[Sales Price]),ALLEXCEPT(Table,Table[material]))
I test using my sample table.
Create a measure using the formula using the formula below and get expected result.
Average = CALCULATE(AVERAGE(Table1[value]),ALLEXCEPT(Table1,Table1[Material]))
Best Regards,
Amgelia
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |