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 , 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
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
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.