topic Re: RankX gives all 1 in DAX Commands and Tips

RankX gives all 1

Anonymous — Fri, 05 Nov 2021 16:43:13 GMT

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?

Re: RankX gives all 1

Greg_Deckler — Fri, 05 Nov 2021 17:16:42 GMT

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

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

Re: RankX gives all 1

AlexisOlson — Fri, 05 Nov 2021 17:30:54 GMT

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

Re: RankX gives all 1

v-yanjiang-msft — Mon, 08 Nov 2021 03:07:55 GMT

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.

Re: RankX gives all 1

Anonymous — Mon, 08 Nov 2021 06:35:55 GMT

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.

Re: RankX gives all 1

AntrikshSharma — Mon, 08 Nov 2021 06:32:15 GMT

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

Re: RankX gives all 1

Anonymous — Thu, 11 Nov 2021 14:36:11 GMT

Using the whole table worked!

Re: RankX gives all 1

Anonymous — Thu, 11 Nov 2021 15:15:00 GMT

But why does this work..

Re: RankX gives all 1

claive — Fri, 09 Jun 2023 01:36:46 GMT

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