Help me fix RANKX

[Sab]

Hello,

I have a table with many columns, among which are Area and the Value. I want to rank the Areas by the Sum of Value. I have created Total Value measure which is a simple SUM of Value. Then I have created these two Rankx measures, which are similar but the first one sort DESC and the second one ASC.

See in the screenshot what I get:

So it works for only 1 Area and all other areas have the same rank value, either 1 or 75 (which is the count of areas -1)

:((((

[Sab · Accepted solution]

This is crazy, just created another table from the original one by applying a simple filter:

ALL_2 = FILTER('All', 'All'[Area] <> "World")

and when created rank measures against this table, they do work!!!

[v-yalanwu-msft]

Hi, @Sab ;

I tested it ,and it is right .can you share your [Total Value] 's measure ,may be it will helpful to  this error.

Rank asc = RANKX(ALL('Table'),[Total value],,ASC)

Or  could you make a simple data and share with us?

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Sab 

Use ALLSELECTED ( 'ALL'[AREA] ) instead of ALL ( 'ALL'[AREA] ) inside your RankX function

[Sab]

Still same result:

[Fowmy]

@Sab 

Without enough information, it's hard to make assumptions. make dummy files with sample data and share them. 

Check your data model and the relationships.

[selimovd]

Hey @Sab ,

the formula looks good.

Can you share the file? There must be something wrong.

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Sab]

Hi, unfortunately I can't share it 😞