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

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. 🙂