Forum Discussion

AniketMS's avatar
AniketMS
Frequent Visitor
2 years ago

Guidance on Improving FE Performance

Hi , 

 

I have a data model with 4 millions records each date and it is in Import mode.

 

IN dax we have implemented to 10 and others logic . 

 

One of the dax is taking more than 30 seconds to run . post analysing it is identified that FE is taking 95% of the time . Please refer the screenshot below.

 

 

Looking forward to seek some guidance on the way / list of points that needs to be checked to improve the FE performance.

 

Thanks!

2 Replies

  • AniketMS's avatar
    AniketMS
    Frequent Visitor

    Appologies it is Top 10 and other logic in Bar chart to be precise.

  • AniketMS 

    DAX optimization is a broad area, just by looking at the timing you have shared it's not possible to identify and tell you what exactly causes the formula engine high usage it's important that I look at the measure, also if you have the data model details this will help. For the time being, please share your measure