Forum Discussion

anil's avatar
anil
Icon for Helper III rankHelper III
8 years ago
Solved

Category Segmentation (Range Buckets) using direct query

My dataset has ID's with multiple orders. I am trying to calculate average discount across orders per ID. And creating a column to bucket the averages of ID's.    Bucket = Switch ( True(), ...
Need Help
Show and Tell
Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi anil,

     

    This is DAX Formula Compatibility limitation. When using DirectQuery mode, aggregation functions like COUNT, SUM, etc are supported in measure only. For more details, please see: DAX Formula Compatibility in DirectQuery Mode. You can switch the table from direct query to import to work around.

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi anil,

 

This is DAX Formula Compatibility limitation. When using DirectQuery mode, aggregation functions like COUNT, SUM, etc are supported in measure only. For more details, please see: DAX Formula Compatibility in DirectQuery Mode. You can switch the table from direct query to import to work around.

 

Regards,

Frank

anil's avatar
anil
Icon for Helper III rankHelper III
8 years ago

Hi v-frfei-msft

 

     Thanks for the reply. But we wanted to create the reports using direct query mode. As the data set, we are working is very huge with constant updates. As power bi import mode data limit is 10 GB only we didn't want to go with import mode.

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi anil,

     

    Maybe you can use composite models to make the Storage Model to be Mixed. For more details, please check the online document.

     

     

    Regards,

    Frank