Forum Discussion
Identify if value is above or below parameters
Hello, I am trying to find the best way to show if a value is over or under a set criteria. I have a list of employees who each have a performance rating assigned to them. I'm trying to show wh...
amitchandak
Super User
Super Usersrjohnson212 , Based on what I got
a new measure =
Divide(countrows(table), Calculate(countrows(Table), allselected()) )
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
Hello amitchandak, I already have the % employees. What I"m looking for is how to get the Under and Over distribution. For example, for Rating 2, the % employees is 45% which is outside (under) of the set range of 55-65%. I'm asking how to I calculate how much the % employees is under or over the set ranges shown in graph.