Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Formatting by Percentage for Low Performers

Hopefully, this is an easy one, I am looking to highlight the bottom 25% of the revenue rank. Ranks are subject to change so I cannot place values as the rule.        
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

The Rank is using the rankx function. 

 

 

It seems to be working okay in this example but is not quite right. I have this same conditional formatting on two separate virtual tables. both with rankx and both with the same group of individuals, there are 41 in this month's example. In the picture above, there is 11 highlighted which is 26.8% close but not exact. People's jobs are being scored on this so I want to make it as precise as possible.

 

 

 in the next example, which is again identical, it's way off, which makes me doubt both conditional formattings. In this example, there are 7/41 highlighted, 17%. 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Any thoughts or workarounds? Or anything else I can provide to help?

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    6 years ago

    Anonymous 

     

    You may use the following measure.

    Measure =
IF (
    [Rank]
        > CONVERT ( COUNTROWS ( ALLSELECTED ( 'Table'[Name] ) ) * 0.75, INTEGER ),
    1
)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I don't know if I was using this wrong or what but it's a no-go as well. I appreciate the help though. 🙂