Forum Discussion

basirve's avatar
basirve
Helper III
5 years ago
Solved

DAX query facing performance issue.

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...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    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's avatar
basirve
Helper III
5 years ago

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.