RANKX Rank specific measure value in table

Question

&nbsp;Hello All,&nbsp;Any help would be greatly appreciated.&nbsp;Example table...&nbsp;Table1Code&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sales$AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/10/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200.00BB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/10/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200.00AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/10/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200.00CC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/10/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200.00DD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14/10/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200.00FF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15/10/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200.00FF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17/10/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200.00AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18/10/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200.00&nbsp;I want to create a specifc ,measure to return me the rank of the string AA amongst the above sales.I dont wish to have a table to collate totals for other reason.The idea will be to have five seperate Measures that store the rank&nbsp;for AA BB CC DD FF.These will be represented in cards on the report - I dont want to have to set Visual filters on each card.&nbsp;is there a way in the RANKX statment where I can specify the text to rank.&nbsp;ie What rank is Code "AA" in Table1.Code field for Sum(Sales$)I have done rank statements before but they have always been for column names and been able to use for any code in the table.In this example I wish to fix the Code and seek a rank for it.&nbsp;Any suggestions welcome and help appreciated in advance.

zubair_muhammad · Accepted Answer

HI shaunwilks&nbsp;Try this MEASURE pattern&nbsp;Measure =
CALCULATE (
    RANKX ( ALL ( TableName[Code] ), CALCULATE ( SUM ( TableName[Sales$] ) ) ),
    TableName[Code] = "AA"
)

Forum Discussion

RANKX Rank specific measure value in table

2 Replies

Related content

RankX

Make measure ignore specific filter

summarize rows based on a row specific measure like rankx

Specific matrix

Advanced Ranking (Rankx)