Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys,
I have created a measure to calculate the value of items based on quantity * cost
Cover Value =
SUM('View_Inventory_with_Locations'[cost]) * [Cover]
The vaules of the items are correct, yet the 'Total' is bizare and way off
As its a measure there seem no way of changing how the total is caluclated, i.e. sum, count etc?
Can anyone advise please?
Solved! Go to Solution.
Try this but replace "Item" and "Item[Number]" with whatever dimension you're using in the matrix.
Measure =
SUMX(
SUMMARIZE( Item ,
Item[Number],
"Value" , SUM(View_Inventory_with_locations[cost]) + [Cover]
), [Value]
)
Br,
J
Many thanks for that suggestion, not exactly sure I understand this, as it seems very complex, but will go through the other links and try to understand this issue and the cause.
Try this but replace "Item" and "Item[Number]" with whatever dimension you're using in the matrix.
Measure =
SUMX(
SUMMARIZE( Item ,
Item[Number],
"Value" , SUM(View_Inventory_with_locations[cost]) + [Cover]
), [Value]
)
Br,
J
What power bi does is:
Sum('View_Inventory_with_Locations'[cost]) * SUM([Cover])
Meaning the total of a measure is a measure in itself.
Not what you want and what you expect but if you dive deeper in Power BI it makes sense
Maybe this thread can point you in the right direction
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/m-p/63376#U63376
I got it from
https://community.powerbi.com/t5/Desktop/Total-Sum-of-a-measure/td-p/110702 This thread shows a simular issue
Hello @lesg,
Check if this article helps in your case https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |