topic Come up with a score based on measures condition in DAX Commands and Tips

Come up with a score based on measures condition

Suprith — Thu, 17 Dec 2020 23:30:33 GMT

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

Re: Come up with a score based on measures condition

amitchandak — Fri, 18 Dec 2020 03:28:20 GMT

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
)

Re: Come up with a score based on measures condition

Suprith — Fri, 18 Dec 2020 04:29:30 GMT

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

Re: Come up with a score based on measures condition

amitchandak — Fri, 18 Dec 2020 05:41:12 GMT

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
)

Re: Come up with a score based on measures condition

Suprith — Fri, 18 Dec 2020 07:04:39 GMT

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

Re: Come up with a score based on measures condition

Suprith — Fri, 18 Dec 2020 17:50:35 GMT

It worked 🙂 , thanks a lot for your help.