Forum Discussion
Measure Total Incorrect
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?
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
5 Replies
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,
JHello 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 👍
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
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.
This all seems ridiculous to me. You should be able to choose how you want your final total row calculated. Most of us just want the total at the bottom of the table to be the total of all the values displaying in the column, not some bizarre alternative calculation.
