Forum Discussion
Slow performance with DAX
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,
1 Reply
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