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

Hi v-jingzhang , thanks for trying this out. The 'Units' and 'UnitSell' are decimal and currency data types respectively. The source is from a table in Dataverse. The only transformation in power query editor is to filter some rows and rearrange columns.

 

Many thanks.