Simple Sequential rank / number column added to table

[chrisparker3268]

I have table 'Append 1' visual sorted by [% Compliant] and filtered on >=1 (100%) [% Delivered[. I want to rank these by % Compliant. I have tried the rankx function for a new mesure but get varying results. I cannot seem to get a simple out that ranks by % compliant.

Site	% Compliant	% Delivered	# Non-Compliant
Chillicothe	99.80%	100%	3
Des Moines	99.40%	100%	12
White City	99.20%	100%	9
Boise	99.20%	100%	21
Portland	98.40%	100%	90
Seattle	98.30%	100%	122
Roseburg	98.20%	100%	34
Northern Indiana	98.00%	100%	53
Alaska	97.60%	100%	32
Dayton	97.40%	100%	86
Cincinnati	97.30%	100%	96
Indianapolis	97.30%	100%	119
Danville	97.00%	100%	53
Ann Arbor	96.40%	100%	163
Battle Creek	95.90%	100%	101
Saginaw	95.30%	100%	103
Salt Lake	92.80%	100%	283
Sioux Falls	92.00%	100%	138
Detroit	91.10%	100%	252
Fort Harrison	90.90%	100%	195
Cleveland	90.60%	100%	675
North Chicago	94.80%	95%	148
Iron Mountain	92.10%	94%	97
Marion	96.00%	93%	90

[v-yanjiang-msft · Accepted solution]

Hi @chrisparker3268 ,

According to your description, in the visual filtered for [% Delivered]>=1, you want to create a measure to rank the %compliant. Here's my solution.

Rank =
RANKX (
    ALLSELECTED ( 'Table' ),
    CALCULATE ( SUM ( 'Table'[% Compliant] ) ),
    ,
    DESC,
    DENSE
)

Get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You have duplicates in the data. The Rank function needs help deciding how to sort these. What is your expected outcome and why?