Dax Query Slow performance

[basirve]

Dear Experts,

Below Dax Query having slow perfomannce , Could you please suggest the best approach.

_rankNPS_supervisorTeamLead_network =

RANKX

(

CROSSJOIN

(

ALL(Dim_Agent[Job_Description]) ,

ALL(Dim_Agent[Team_Lead_Complete_Name]) ,

ALL(Dim_Agent[Supervisor_Complete_Name]) ,

ALL(Dim_Agent[Manager_Complete_Name]) ,

ALL(Dim_Agent[Director_Complete_Name])

) ,

CALCULATE

(

[_AvgNPSSelectionMTD] ,

Dim_Agent[_MissingHierarchy1] = "|||"

) , ,

DESC ,

Skip

)

Thanks & Regards,

Venkat

[V-pazhen-msft · Accepted solution]

@basirve 

I guess runing both rankx and crossjoin with a measure is the problem.
Try create a calculate table first with crossjoin, then create the rankx measure.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @basirve ,

always difficult to do a performance analysis without the data.

But I guess the RANK over the CROSSJOIN is causing the trouble. Is there a way to solve that without the crossjoin?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi