I am having question. I have situation when in one case sum of rows values in table is correct in another case when I adding new column in visual, then appears new row and sum of rows becomes incorrect. How I could fix it?
6264,00+33,71+34,80 is not equal 6298,75 This comes 3 lines if I add OBJ_KOD column.
6264,00+34,80 is equal 6298.. Here getting two lines without adding OBJ_KOD column. in table
So how to resolve this issue?
ISINSCOPE ( tb[OPALGA_MEN] ),
DIVIDE ( [total_sum_tb], [sum_hs_tb] ),
VAR summaryTable =
VALUES ( tb[OPALGA_MEN] ),
"@val", DIVIDE ( [total_sum_tb], [sum_hs_tb] )
SUMX ( summaryTable, [@val] )
Here is a measure for a last column in visual.