cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

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?

1 ACCEPTED SOLUTION
Super User

@karma123

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
6 REPLIES 6
Helper II

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

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.

Super User

@karma123

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper II
Thank you so much! This has now worked 🙂
Super User

@karma123

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper II

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?

Super User

@karma123

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 )
)
``````

Did I answer your question? Mark my post as a solution! and hit thumbs up

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors