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[Staffing...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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]))