Slow performance with DAX

[Anonymous]

Hi,

The following measure is taking to long to run 65238 millseconds. how can i re write as a VAR format or Please suggest any other way to imrove the performance.

DownTrend = 
CALCULATE (
IF (
ISBLANK ( COUNTA ( 'DIm_Product'[Product_ID]) ),
BLANK (),
COUNTA ( 'DIm_Product'[Product_ID)
),
FILTER (
ALLSELECTED ('Dim_Sales'[Year_IND] ),
CALCULATE('_Measures'[p-value]<=0.05 && 'Dim_Sales'[TAU 1] < 0)
)
)
+0

Thank you,

[v-shex-msft]

Hi @Anonymous ,

If you can please share pbix file with some sample data for test, it is hard to test your formula without any detail data.

How to Get Your Question Answered Quickly  

In addition, have you nested any measures in your conditions? If this is a case, it may cause performance issues.

Optimizing nested iterators in DAX 

Regards,

Xiaoxin Sheng