Measure Total Incorrect

[lesg]

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?

[Brer_J_Cooper]

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. 

[lesg]

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.

[tex628 · Accepted 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

[RemyO]

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

[Idrissshatila]

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 👍

Follow me on Linkedin