Forum Discussion
RankX
RankX measure in card visual is showing a different number to the rank displayed in a table visual, Is there any solution for this?
Anonymous
I have attached a file for you, please check. It works for me.
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.
Anonymous
I have attached a file for you, please check. It works for me.- Thank you so much! This has now worked 🙂