Using RANKX for TOP 15% Not Working

[KMcCarthy9]

I have a table that holds uniqueasset and asset age and I am trying to create a dynamic filter in order to show the Top 15% of the oldest assets. I created a uniquerank column since there are many duplicates of asset age.

Measures created:

UniqueRank = 
RANKX(
    Data,
    Data[asset age] * 1000000 + Data[Index],
    ,
    DESC,
    DENSE
)

TotalAssets = COUNTROWS(ALL(Data))

Top15PercentCount = CEILING([TotalAssets] * 0.15, 1)

Top15PercentThresholdRank = 
CALCULATE(
    MAXX(
        TOPN([Top15PercentCount], ALL(data), data[UniqueRank], DESC),
        data[UniqueRank]
    )
)

I then created a column to use as a filter:

IsTop15Percent = 
IF(
    MAX(data[UniqueRank]) <= [Top15PercentThresholdRank],
    1,
    0
)

However, when I use as a filter it is placing all assets/rows into the Top 15% when I believe it should be flagging 1,876 of them. 

What am I doing incorrectly? pbix file here: Top 15 Percent Oldest Assets 

TIA! 

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

[KMcCarthy9]

@Jihwan_Kim This works! Thanks so much! 

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[KMcCarthy9]

@Ashish_Mathur Your method also appears to work, however I did not try it in my actual data model, but your example is correct. Thank you! 

[Ashish_Mathur]

You are welcome.