cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Come up with a score based on measures condition

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

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

5 REPLIES 5
Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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
)



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

It worked 🙂 , thanks a lot for your help. 

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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.