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.
I have created a measure for ASP which is
But this measure does not work at all.
THe measure should be Sales/Item Quantity for every Account ID
Can someone please guide me where the measure is failing and what might be the solution.
Solved! Go to Solution.
@Avivek
Create a measure for Qty as
Qty =SUM(Sales[Item Qty])
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Avivek
Create a measure for Qty as
Qty =SUM(Sales[Item Qty])
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy , the measure works for the overall total for an account but the individual records shows wrong values.
In the above image, Qty and ASP is the measures you had suggested and Measure2 is the old measure I had created. Both the measures give similar result but if you see the 1st record then with the measure of Qty it shows 6 instead of 3, similarly the 3rd record for Qty measure shows 4 instead of 2. I believe that is why the measure is calculating as (2712/6) whereas it should be (2712/3).
Do you know what is the change in the measure I can do to get the appropriate result.
Hi,
The formulas suggested by Fowmy have to be written as measures (not calculated column formulas).
Hi @Avivek ,
Basically the formula as @ Fowmy mentioned should work. Did the [Item Qty] column is a calculated column or a normal column in your table? If it is a calculated column, how did you calculate it?
Could you please consdier sharing a sample file for further discussion?
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Avivek
Is "Item Qty" a measure?
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Oh sorry @Fowmy , actually the Sales amount is a measure and Item Quantity is a column.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
It still shows wrong value
Can you please tell if ther is anything else we can do
@Avivek
Try the following measure:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thankyou @Fowmy , but sales amount is a measure so i cannot use sum(sales amount)
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |