Forum Discussion
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
- AniketMSFrequent Visitor
Appologies it is Top 10 and other logic in Bar chart to be precise.
- FowmySuper User
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