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.
Power BI always does the following.
1. takes a single number from a visual
2. determines what filters are impacting this number from the visuals
3. determins if there are any other filters being used by CALCULATE
4. Combines all filters from 2 and 3, applies these filters to the data model
5. If the tables are joined, the filters propagate in the diretion of the arrows on the relationships
6. The answer is calcualted and return to the visual.
7. Repeat for every cell/number in a visual.
A Total Row is exectued in exactly the same way. There is no concept of totals or subtotals, only filter and then calculate.
tnx matt,
how can i perform calcultions on current visual level of matrix data . cause i need just simple arthematic calculations ,regardless of any filter or joins.
Sorry, I don't understand what you are asking. Are you saying you want a calcuation that ignores any filters? In that case you use
=calculate([original measure],ALL(TableNameThatNeedsFiltersRemoved))
tnx for reply MattAllington , please check my screenshot, this is my issue , i cant understand how power bi calculated the rowwise subtotal,
i just want to have sum of the rows in visual level ,i mean only sum of row wise values, as appeared in the visual.cause now the sub total is not the sum when i manually calculate it.
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.
