topic Re: RankX in DAX Commands and Tips

RankX

Anonymous — Fri, 08 Dec 2023 23:49:07 GMT

RankX measure in card visual is showing a different number to the rank displayed in a table visual,

Is there any solution for this?

Re: RankX

Fowmy — Sat, 09 Dec 2023 07:17:42 GMT

Anonymous

Yes that's correct, it all depends on the context on which the calculation happens. Please provide some data and the expected results.

Re: RankX

Anonymous — Sun, 10 Dec 2023 18:00:26 GMT

I am using the RANKX(ALL(Category[Category Names]), [Premium]) formula in the table and card visual. When I filter for a specific category it gives a different result in the table and card visual.

Do I need to use a different measure for the card visual?

Re: RankX

Fowmy — Sun, 10 Dec 2023 19:00:14 GMT

Anonymous

You can use the same measure for both as follows. Change DESC to ASC if needed.

Rank Category = RANK( DENSE, ALL(Category[Category Names], ORDERBY( [Premium], DESC ) )

Re: RankX

Anonymous — Sun, 10 Dec 2023 22:22:28 GMT

I tried the following but am getting blank appear in the visual.

Test Rank = RANK( DENSE, ALL(Category[Category Names]), ORDERBY( [Premium], DESC ))

Note the premium amount is a DAX measure that has been used.

In the card visual I am adding a filter to select only one category.

Example Data as below

Rank Category Premium

1 Food £100

2 Lifestyle £80

3 Transport £60

4 Education £20

When I put transport in a card it gives the rank as 4 when it should be 3 as shown in the table.

Re: RankX

Fowmy — Mon, 11 Dec 2023 06:50:12 GMT

Anonymous

I have attached a file for you, please check. It works for me.

Re: RankX

Anonymous — Mon, 11 Dec 2023 14:16:02 GMT

Thank you so much! This has now worked 🙂