Conditional Formatting by Percentage for Low Performers

[Anonymous]

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.

[Greg_Deckler]

So...what is the issue??

[parry2k]

@Anonymous Revenue Rank is a calculated column or a measure? What you have shown in the screenshot, is that not working?

[Anonymous]

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]

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

[v-chuncz-msft]

@Anonymous 

You may use the following measure.

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

[Anonymous]

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