Wrong/different sum when using different fields

[Benedikt_Sch]

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 but with other dimensions this value changes.

If it were only small deviations I would have suspected roundings.

I have only loaded one table. No transformations were done or filters set. How can it be that the totals are different?

I have also tried the show items with no data option. No difference. All data of the dimensions are filled, no null values.

Does anyone have an idea what the problem could be?

Greetings

Benedikt

[Benedikt_Sch]

Update 2:

If i do refresh. the total sums for the imported Data query also changes every time 😲.

Direct query sums, still the same.

[Benedikt_Sch]

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 1	Sum 2
EVALUATE(         SUMMARIZECOLUMNS(              "IsGrandTotalRowTotal"),             "Sum a", (SUM('Query1'[Column a ])),         ) )	EVALUATE(         SUMMARIZECOLUMNS(             ROLLUPADDISSUBTOTAL('Query1'[DIM_stil], "IsGrandTotalRowTotal"),             "Sum a", (SUM('Query1'[Column a ])),         ) )
8360059,40400025	8360059,77300027