DAX query facing performance issue.

[basirve]

Dear Experts,
Below Dax Query facing perfomance issue, Could you please provide Best soulution for below DAX Measure.

Note: _productivity is measure, Its contain sum(column).

Intention Of below code is need to get the Min value of productivity at @ReportstoName,_NameID level.

Note: Below code is taking to execute 1350 Ms, Please provide the best solution on this.

productivity_MinVal =

MINX(
FILTER(
ALL(
Employee_Lookup[Reports_To_Name],
Employee_Lookup[_nameId]

),
Employee_Lookup[Reports_To_Name] = MAX(Employee_Lookup[Reports_To_Name]) && [_productivity]>0

),
[_productivity]

)

Thank you in advance,

Regards,

Venkat.

[basirve]

How to Optimize below Dax query.

RANKX (
ALL ( Denodo_Employee_Lookup_CRC_Personnel[_nameId] ),
CALCULATE (
CALCULATE (
UCCE_Productivity[_AHT_Resi_Duration],
Denodo_Employee_Lookup_CRC_Personnel[Job_Cd] = "DSWQ", Denodo_Employee_Lookup_CRC_Personnel[Status] in {"Active Fulltime","Leave of Absence"}, Denodo_Employee_Lookup_CRC_Personnel[Network_Id] <> BLANK ()
),
ALLEXCEPT (
Denodo_Employee_Lookup_CRC_Personnel,
Denodo_Employee_Lookup_CRC_Personnel[_nameId]
), Denodo_Employee_Lookup_CRC_Personnel[Job_Cd] = "DSWQ", Denodo_Employee_Lookup_CRC_Personnel[Status] in {"Active Fulltime","Leave of Absence"}
),
,
ASC,
DENSE
)

Could you please help me on this.

[Icey · Accepted solution]

Hi @basirve ,

To my knowledge, this expression is very simple now. 

What's the size of your data? If it is large, this calculation time is normal.

In addition, you can also try something like below:

productivity_MinVal =
CALCULATE (
    MINX ( VALUES ( Employee_Lookup[CRR] ), [_productivity] ),
    ALL ( Employee_Lookup[CRR] )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[basirve]

Dear Icey,

Its Really helffull, Thank you a lot!.

Regards,

Venkat