Forum Discussion
Wrong total
Typically this problem is because the calculation for the total line is not just adding up the individual lines, it is calculating the measure in the context of the total.
If you want to instead sum up the individual values, you need to create another measure which you will use in the visual instead of the current one, and this will depend on which column you are using the table or matrix visual. If you were using e.g. 'Table'[Column] in the visual, then you could create a measure like
Total Besparelsespotentiale (gulv) = SUMX( VALUES( 'Table'[Column] ), [Besparelsespotentiale (gulv)] )
Typically this problem is because the calculation for the total line is not just adding up the individual lines, it is calculating the measure in the context of the total.
If you want to instead sum up the individual values, you need to create another measure which you will use in the visual instead of the current one, and this will depend on which column you are using the table or matrix visual. If you were using e.g. 'Table'[Column] in the visual, then you could create a measure like
Total Besparelsespotentiale (gulv) = SUMX( VALUES( 'Table'[Column] ), [Besparelsespotentiale (gulv)] )