Forum Discussion

arobinson's avatar
arobinson
Frequent Visitor
5 years ago

Slow DAX

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

  • AntrikshSharma's avatar
    AntrikshSharma
    Community Champion
    5 years ago

    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.