RANKX top 3 and multirow card

DAX DAX Calculations
1

Hi,
I have two questions I would like some help with please:

  1. I would like a table to show Top 3 ranked Products and have used
    TOP3 = if([RANKX]<=3,[Total Profit],BLANK()) however still showing rank 4 & 5.
    image

  2. I am using Multi-Row card visual, I would like the visual to sort by Rank, It this possible? In my Image, I would like to see Product 4 first, then product 3, product 2 etc.

    image
    image642Ă—506 70.1 KB

File is attached :pray: :pray: :pray:
Rank.pbix (19.7 KB)

2

Hello @KimC,

Thank You for posting your query onto the Forum.

As for the first query, where you want to see the “Top 3” results. The way you’re trying to achieve is not possible because alongside “Top 3” measure you’ve also substitued other measures as well into the table visual. And the condition to go blank is specified under the “Top 3” measure only and not under all the measures. So it’s exactly evaluating the results as per the way the conditions are specified into each individual measures. The only way to filter the entire table visual is to put the “Top 3” measure into the FILTER PANE and select the option of “Is Not Blank” like you’ve already done for the second table visual.

Now, with regards to the sorting by ranking option it’s possible. Just click onto the “Multi-Row Card” to activate that visual and then click onto the 3 dots and under “Sort By” option select the “RANKX” option and it’ll sort the results as per rankings where Product 4 will be seen on the top. Below is the screenshot provided for the reference -

Results
Results961Ă—512 34.4 KB

Hoping you find this helpful. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

3 Likes
3

Hi @KimC,

An alternative could be to create separate display measures that blank out values, like you did with the TOP3 measure. Using those instead of the other measures means you don’t have to set visual level filters.

Changed your RANKX into

RANKX = 
VAR _Rank = RANKX( ALL( Table1[Product]), [Total Profit], , DESC, Skip )
RETURN
    IF( _Rank <=3, _Rank )

.
And created display measures with this pattern

image
image1140Ă—318 18.8 KB

Like @Harsh already illustrated you can set the RANKX visual sort order on the multiline card.

.
Here’s your sample file:
Rank.pbix (20.1 KB)

I hope this is helpful

2 Likes
4

Amazing and so simple @Harsh , thank you. I spent over an hour trying to work that out!!!

1 Like
5

Hello @KimC,

You’re Welcome. :slightly_smiling_face:

We’re glad that we were able to assist you.

Thanks and Warm Regards,
Harsh

1 Like
6

Thankyou for replying @Melissa, any chance I could see the file with your solution? It is not working for me still

1 Like
7

Hi @KimC,

Sure I’ll add that to my initial response.
All the best

1 Like
8

Thanks so much @Melissa, perfect. I missed the step that I had to create every measure as an if statement.

2 Likes