Come up with a score based on measures condition

[Suprith]

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

[amitchandak]

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

[Suprith]

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 

[amitchandak · Accepted 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]

It worked 🙂 , thanks a lot for your help. 

[Suprith]

Thanks Amit, will try this and let you know the outcome. Much Appreciated.