Max Number of RankX

[BileMG]

Hi, 

I use a RankX measure to calculate the Rank of different values.

This works fine but in addition to that Information I want to show the place in the ranking, i.e. Rank X from Y.

But I could'nt find a DAX that I can use to calculate the Y.

Does anybody have an Idea ?

[v-yuta-msft]

Hi BileMG ,

What does "place in the ranking" and "Rank X from Y" mean? Could you please clarify more details about your expected result?

Regards,

Jimmy Tao

[BileMG]

Hi,

my current measue calculate the Rank of Sales in a  team and in a period. I show it in a card, for example the Sales of BileMG is 30K, he is on Rank 5 of ? ?. This figure makes more sense, when I also could show the place in the Rank. Rank 5 of 30 has another impact ob performance that he ist on Rank 5 of 5.

[Zubair_Muhammad · Accepted solution]

@BileMG

Try this pattern

Measure MaxRank=
MAXX ( ALLSELECTED ( TableName[Team] ), [RankMeasure] )

[BileMG]

Thanks @Zubair_Muhammad

This works.