RankX gives all 1

[Anonymous]

Hi My rankX gives all 1. 

This is the code 

Ranking = RANKX(

ALL(Enhet[Enhet])

, [Medelkontinuitet])

I've acctually done a lot of rankings before with this exact concept that is:

Ranking = Rankx(
All("some category reference in a column"), 
 [measure])

I have relationship between the enhet table ande kontinuitet table which is were the measure is calculated from..... 

Any ideas why it is behaving this way? 

[AntrikshSharma]

@Anonymous Are you using the same column inside RANKX and the Visual/Matrix?

[Anonymous]

Hi @Anonymous ,

Rank = RANKX( ALLSELECTED( 'Enhet' ) ,[Measure] )
Hope so this will resolve your query.
Please accept it as a solution if you achieve the required target.

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

By my test, there may be two reasons for your problem.

1.You can modify your formula to “Ranking=RANKX(ALL(Enhet),[Medelkontinuitet])”.

2.If it still not work, you can verify if the measure “[Medelkontinuitet]” has the same value in the table “Enhet”.

Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[claive]

Hi,

I'm having the same problem,

I created a measure from the same table.. BAD measure is also from CSAT Table.

Rank = Rankx(ALL ('CSAT'),[Bad])

[Anonymous]

But why does this work.. 

[Anonymous]

Using the whole table worked! 

[Greg_Deckler]

@Anonymous See if this helps. You probably need a CALCULATE or something:

To *Bleep* with RANKX! - Microsoft Power BI Community

[AlexisOlson]

If you're calling a measure, then there's an implicit CALCULATE already.