Different results dependent on the table mode (DQ vs Import)

[yackpl]

Hi Experts,

I have some problem/question.

I've got measure which highlights max value on the column chart:

but this measure gives me different results dependent on the table mode (Direct Query and Import):

Do you have any suggestions?

Thank you in advance.

[Greg_Deckler]

@yackpl I'm guessing it has something to do with precision and significant digits but really hard to say. DAX overview - DAX | Microsoft Learn

That said, I have no idea what [% nieobecnosci] is in terms of its formula.

[Greg_Deckler]

@yackpl Try getting rid of your CALCULATEDTABLE, you don't need it as you can write it as:

VAR monthlyAbscence = 
  ADDCOLUMNS(
    SUMMARIZE(ALLSELECTED('DATA'), ...

Otherwise, you may have a situation where a related table is not in Hybrid mode and is thus affecting your imported table but not your DirectQuery table. 

[yackpl · Accepted solution]

@Greg_Deckler ok, I've changed the measure, but it doesn't help.

I found something strange (for me), there is a difference (very small) beetwen measure and created table:

I used ROUND to deal with this problem and it works. But why there is a difference?