Slow DAX

[arobinson]

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]))

[AntrikshSharma]

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

[amitchandak]

@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]))