Dax Execution taking lot of time

[Akhil_1411]

Hi All,

I am trying from past couple to days to optimize my dax, it is taking time to execute "49230" ms which is more time.

Can anyone suggest me any tweaks so that i could excute the dax with the less amout of time.

Below is the dax screenshot and time that is taking to execute.

Dax

Time

Thanks,

Akhil

[Akhil_1411]

Because of this above issue i do see error in power bi service.

[Greg_Deckler]

@Akhil_1411 - I do not understand your use of KEEPFILTERS there. Seems like that FILTER statement could be simplified to a large degree but unsure because of no sample data to test with. Could you post sample source data as text as well as your formula as text so that I can mock this up and test it out? DAX performance issues are tough to solve. 

I have some DAX Performance Tuning articles here:

• https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-1/ba-p/976275
• https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-2/ba-p/976813

These are also good articles:

• https://maqsoftware.com/expertise/powerbi/dax-best-practices
• https://www.sqlgene.com/2019/09/27/a-comprehensive-guide-to-power-bi-performance-tuning/
• Video: https://
• ww.sqlbi.com/tv/optimizing-analyzing-dax-query-plans-sqlbits-xii/#
• https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

Sorry for the link spam but it's a broad topic and the information you have provided is limited.