Forum Discussion

Benedikt_Sch's avatar
Benedikt_Sch
Helper I
3 years ago

Wrong/different sum when using different fields

  hello, I have a strange problem and unfortunately can not find out the reason. I load data of a table with facts and dimensions. When I select a measure I get a sum. If I call the same mesasure ...
Need Help
Benedikt_Sch's avatar
Benedikt_Sch
Helper I
3 years ago

i have new informations for this problem.

The tables have 4.000.000 Rows and the measure is a decimal (38,6).

If I do it via direct query, all sums are the same. But if I use import mode without any additional steps, the sums seems to be corrupt.

 

I can also reproduce it via Dax.

 

 

Sum 1Sum 2 
EVALUATE(
        SUMMARIZECOLUMNS(
             "IsGrandTotalRowTotal"),
            "Sum a", (SUM('Query1'[Column a ])),
        )

)		EVALUATE(
        SUMMARIZECOLUMNS(
            ROLLUPADDISSUBTOTAL('Query1'[DIM_stil], "IsGrandTotalRowTotal"),
            "Sum a", (SUM('Query1'[Column a ])),
        )

)		 
8360059,404000258360059,77300027