Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am trying to score a server based on certain parameters, for example if below measures satifies the condition, then Server's score is 100 , otherwise assign a lower score. Can i use variables to assign a score ?
Note : I am comparing below measures against the threshold limit.
[CPU_Utlization] < 80%
[Memory used] < 80%
[Disk Used] < 75%
[Failures] = 0
Solved! Go to Solution.
@Suprith , Create like
Switch( True (),
[CPU_Utlization] < .8 , 10 ,
[CPU_Utlization] < .9 , 9 , // Say
0
) + Switch( True (),
[Memory used] <.8 , 10 ,
[Memory used]< .9 , 9 , // Say
0
)
@Suprith , if the above are columns create a new column, if they are measure create a new measure
Switch( True (),
[CPU_Utlization] < .8 && [Memory used] .8 && [Disk Used] < .75 && [Failures] = 0 , 100 ,
[CPU_Utlization] < .8 && [Memory used] .8 && [Disk Used] < .75 && [Failures] <=5 , 90 , // Say
0
)
Thanks Amit, but is there a way we can start adding up a score, say
if CPU < 80%, Score = 10
if Memory < 80%, Score = 10 + 10 = 20
if Disk > 80% , then score = 20+ 5 (instead of 10 as it is above the threshold) , finally return the score
@Suprith , Create like
Switch( True (),
[CPU_Utlization] < .8 , 10 ,
[CPU_Utlization] < .9 , 9 , // Say
0
) + Switch( True (),
[Memory used] <.8 , 10 ,
[Memory used]< .9 , 9 , // Say
0
)
It worked 🙂 , thanks a lot for your help.
Thanks Amit, will try this and let you know the outcome. Much Appreciated.