Forum Discussion

phchu1226's avatar
phchu1226
Icon for Helper IV rankHelper IV
4 years ago

Issue after changing direct query mode to import mode

Hi,   I just changed the storage mode from direct query to import, others remain unchanged and the table is wrong after that (should be 100%). I used the same SQL statement to extract data, and al...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi phchu1226 , 

Obviously, you have made changes to the formula.

 

Old measure:   ALLEXCEPT ( 'B',B[CUST_NAME],'B'[TYPE] ) ), 

New measure:ALLEXCEPT ( 'B',CUSTOMER[CUST],'DATE'[DATE] ) ),

 

I don't have your data to analyze this formula.  

 

CALCULATE (SUM('B'[COUNT_PO]), ALLEXCEPT ( 'B',B[CUST_NAME],'B'[TYPE] ) ),

CALCULATE (SUM('B'[COUNT_PO]), ALLEXCEPT ( 'B',CUSTOMER[CUST],'DATE'[DATE] ) ),

 

The two answers may different. You can create measures to compare the differences. Two different formulas lead to different results.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

phchu1226's avatar
phchu1226
Icon for Helper IV rankHelper IV
4 years ago

hi Anonymous ,

 

But my question is that why the result is different while I am just changing the storage mode?

Dataset, relatioship, measure, field name, nothing changed.