Guidance on Improving FE Performance

[AniketMS]

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!

[Fowmy]

@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

[AniketMS]

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