Forum Discussion
Table not totalling correctly
There is not enough information here to confirm if this is a bug or not. It is very common in DAX that the totals don't add up to the individual row items. Your SUMX doesn't appear to iterate over the Train ID, so it is quite possible this is the problem. Try re-writing your formula like this (to verify if it is the cause).
Total train capacity = SUMX(TableName[Train_ID],SUMX(SUMMARIZE(Vehicle_Movements,Vehicle_Movements[Wagon and number],Vehicle_Movements[Total wagon capacity]),Vehicle_Movements[Total wagon capacity]))
Note I don't know what the table name is that contains the train_ID. you will have to fix that. Also I am not saying this is a good formula, but it should tell you if the issue is a bug or a bad formula.
This blog post is a completely different topic, but it explains the "totals don't add up problem". http://exceleratorbi.com.au/sum-vs-sumx-in-dax/
Sorry if you already know this stuff.
rezaieehsan with out understanding the data and how any filters or relationships may be effecting the result, I have had similar issues in the past where the row totals did not match the grand totals. Like Matt answered in the original post sometimes it can be due to how the data is being filtered and what references/relationships are being used.
tnx GilesWalker i am trying to get it correct but still ,even i removed filters but no results.