Forum Discussion
Rank difference between matrix and card
Hello. I've seen some other people here with the same problem and I've tried all the solutions but none worked for me. Basically, I have a ranking of companies by their 12 months accumulated revenues of a certain quarter (like, if the data is about the Q4 of 2022, it will show the revenues from December 2021 to December 2022) and I need to put on a card the position in the ranking of only one of these companies. However, its position appear wrong when I filter in the card or even when I filter to appear just this company in the matrix. I can't share the database since it's confidential but this is the measure that I'm using for the ranking:
Rank Revenue= RANKX(ALL(Database[Group Name]),Database[Total Revenue])
I've tried other measures too, for example:
Revenue Rank =
IF (
HASONEFILTER ( Database[Group Name] ),
RANKX (
ALL ( Database[Group Name] ),
CALCULATE ( SUM ( Database[Revenue] ) ),
,
DESC
)
)
And
Individual Company Rank = RANKX(ALL(Database[Group Name]), CALCULATE(Database[Total GWP], ALLSELECTED(Database[GWP])),,0,Dense)
But the same problem continued. Here is a screenshot of the problem. The card is supposed to show the position of the company in blue but, as you can see, it is the 14th in the ranking but it appear as the 15th in the card. This happens with some other companies but not with all of them
1 Reply
- lbendlinSuper User
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). We can't help you if you don't provide sample data.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523