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 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.

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.

3 Replies

  • Icey's avatar
    Icey
    Community Support
    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

      Dear Icey,

       

      Its Really helffull, Thank you a lot!.

       

      Regards,

      Venkat

  • 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.