Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SUMX issues - converting from Import to DirectQuery

Hi - I'm hoping someone can help. I'm switching from an Import report to a DirectQuery and recreating the measures I created for the Import tables. One of the measures I have that worked using Import...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    I could not reproduce this. I import your data into a SQL Server database and connect to it in Direct Query mode. When I use this measure in a matrix visual, it works well. 

     

    What data types are your units and unitsell columns in the data source? Do you perform any transformation steps in Power Query Editor? 

     

    Regards,
    Community Support Team _ Jing

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous 

 

I could not reproduce this. I import your data into a SQL Server database and connect to it in Direct Query mode. When I use this measure in a matrix visual, it works well. 

 

What data types are your units and unitsell columns in the data source? Do you perform any transformation steps in Power Query Editor? 

 

Regards,
Community Support Team _ Jing

Anonymous's avatar
Anonymous
Not applicable
5 years ago

After creating a new dataset with the data and not applying any 'type' as 'decimal' to the columns I managed to get this working. Thanks for sowing the seed. I just needed to ensure the columns had the right type set. Thanks so much!