Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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
    4 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
Community Support
4 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
    4 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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 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.