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
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

phchu1226 I think my fundamental question is, did you create these measures or not? if yes, what is the expression? There is a reason why I'm asking this? At what granularity you are looking at the data? 

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

    parry2k 

     

    Thanks for reply.

    First of all, do you know the answer of this question?

    Suppose changing the storage mode (just clicking one button) will not affect any data?

     

    did you create these measures or not? what is the expression?

    ->  I mentioned above, column a / column b  * 100% = column c (measure)

    direct query:

    import:

     

    At what granularity you are looking at the data? 

    -> I just want the % is calculated correctly