topic Re: Slow DAX in DAX Commands and Tips

Slow DAX

arobinson — Tue, 11 May 2021 15:11:43 GMT

Hey,

For some reason, these Dax commands are taking quite a bit of time to load. Any help is appreciated..

Scoring Total =

IFERROR (

VAR _selvalue =

SELECTEDVALUE ( ClientData[StaffingSpecialist] )

RETURN

[HCP New Utilization Goal] * .1 + [HCP Old Utilization Goal] * .1 + [Call Score] * .2 + [Hours Goal] * .6,

BLANK ()

)

Ranking Scores = RANKX(ALLSELECTED(ClientData[StaffingSpecialist]), Calculate(Scoring[Scoring Total]))

Re: Slow DAX

amitchandak — Wed, 12 May 2021 03:59:50 GMT

arobinson , avoid if error. I also do find role of selected value

Try

Scoring Total =
[HCP New Utilization Goal] * .1 + [HCP Old Utilization Goal] * .1 + [Call Score] * .2 + [Hours Goal] * .6,

Ranking Scores = RANKX(ALLSELECTED(ClientData[StaffingSpecialist]), Calculate(Scoring[Scoring Total]))

Re: Slow DAX

AntrikshSharma — Wed, 12 May 2021 06:01:40 GMT

arobinson Include code of other measures as well, currently not enough information available to optimize it, only suggestion I can give is don't call IF function in a row context.