Forum Discussion

hrathi38's avatar
hrathi38
Regular Visitor
8 years ago

DAX Improvement

I was just preparing a few measures that'll be hitting against million of records, thus taking a lot of time. I have two DAX formula's that I've written in measures in SSAS (Tabular). All I seek here...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi hrathi38,

 

As the query need to fetch million of records which is a large dataset loaded into desktop, this would slow down the formula execution and report generation and data refresh. I would suggest you filter out unnecessary data to improve report performance.

 

In your scenario, you could use “Direct Query” mode to connect data. Also, make use of Variables in DAX formula might increase the efficency of a measure.

 

For Formula Engine and Storage Engine, please refer to below links to make better usage of them.

Formula engine and Storage engine in SSAS

optimizing dax expressions involving multiple measures

 

Best regards,

Yuliana Gu

  • hrathi38's avatar
    hrathi38
    Regular Visitor
    8 years ago

    Hi v-yulgu-msft,

     

    I completely agree to the points that you've mentioned, but these are the measures that I've created in SSAS Tabular model designer, which I suppose can function a lot faster to process a million of records as compared to Power BI.

     

    Also, I'm already using Direct Query mode to connect data. And regarding the variables, I think I can surely check on that.

     

    Thanks you so much!

    Harshey