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.
hi, i have the same issue, but I want to know how to find out, what does power bi do exactly in the background to calculate the row-wise sum and also column-wise sum
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))
hi i have somehow same problems to get correct column summurization or rowwise sumurization,
please could u quide me how can i get sum in visual level number from each months.
please check the picture attached
