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 ,

I tried to reproduce your error, but it didn't work.

Please ensure. 

Whether the number of rows in the table changes before and after the changing. Are A and B in the same table? If it is , please try to re-write a measure. If it still doesn't work, please provide a screenshot with sensitive information obscured.

 

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,

 

I changed the highlighted and masked tables from dq to import and tried to rewrite the measure.

It works but I still can't figure out why the measure was affected by the changing of storage mode.

 

Relationship:

1) A[CUST_NAME] M:1 CUSTOMER[CUST]

2) A[TYPE] M:1 DATE[DATE]

3) B[CUST_NAME] M:1 CUSTOMER[CUST]

4) B[TYPE] M:1 DATE[DATE]

 

Old measure: (Result is correct before changing the storage mode but wrong after changing)

RATE =
DIVIDE (
SUM ( 'A'[ORDER_PROCESSED] ),
CALCULATE (SUM('B'[COUNT_PO]), ALLEXCEPT ( 'B',B[CUST_NAME],'B'[TYPE] ) ),
0
) + 0
 

New measure: (Result is correct after chaning the storage mode)

RATE =
DIVIDE (
SUM ( 'A'[ORDER_PROCESSED] ),
CALCULATE (SUM('B'[COUNT_PO]), ALLEXCEPT ( 'B',CUSTOMER[CUST],'DATE'[DATE] ) ),
0
) + 0

 

  • 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.