topic Re: RANKX results x Slicer Results in DAX Commands and Tips

RANKX results x Slicer Results

Anonymous — Wed, 01 Dec 2021 01:15:07 GMT

Hello guys.

I bet it is a simple fix, but I can't quite figure it out.

So I have the Rankx:

Ranking categoria = RANKX(ALL(Folha[Categoria]),[Vantagem])

Everything works fine so far.

However, when I use the slicer, the ranking order changes. For example: the "aposentados" goes from 2nd to 3rd place as shown below:

Any help?

Re: RANKX results x Slicer Results

VahidDM — Wed, 01 Dec 2021 01:20:12 GMT

Hi Anonymous

Is [Vantagem] a measure? or column name? if it's a measure can you share a formula with a sample of your data?

BTW, try this:

Ranking categoria = RANKX(ALL(Folha),[Vantagem])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: RANKX results x Slicer Results

Anonymous — Wed, 01 Dec 2021 01:49:08 GMT

Hello.
Sorry, it is my first post.
[Vantagem] it is a measure.

Vantagem = SUMX('Folha',[Fixa]+[Eventual]+[Função]+[Cet]+[Variável]+[Indenização])

I tried your suggestion, but it did not work

Ranking categoria = RANKX(ALL(Folha),[Vantagem])

Sample data: http://bit.ly/alpimprimir

Re: RANKX results x Slicer Results

VahidDM — Wed, 01 Dec 2021 02:08:14 GMT

Anonymous

Do you use columns from one table in matrix and slicer?

I think your first dax code should works fine unless there is something that is not clear here. Can you share your PBIX file?

download this file: https://gofile.io/d/F9woxk

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: RANKX results x Slicer Results

Anonymous — Wed, 01 Dec 2021 02:19:49 GMT

Sure.
There you go: https://gofile.io/d/BqacsT

Re: RANKX results x Slicer Results

VahidDM — Wed, 01 Dec 2021 03:44:33 GMT

Check this file:

Download link: https://gofile.io/d/To94by

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: RANKX results x Slicer Results

Anonymous — Wed, 01 Dec 2021 03:47:52 GMT

Awesome, man. It works. Thanks a lot.

What did I do wrong?

Re: RANKX results x Slicer Results

VahidDM — Wed, 01 Dec 2021 03:57:05 GMT

Anonymous

TBH, nothing mate.

I changed the method, and used calculated columns rather than Measure.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: RANKX results x Slicer Results

Anonymous — Wed, 01 Dec 2021 04:02:27 GMT

It does not affects performance?

Re: RANKX results x Slicer Results

VahidDM — Wed, 01 Dec 2021 05:59:16 GMT

Well, in a simple way, Measure use CPU and Calculated Column use Ram [memory] 🙂
If you use Calculated column that will increase your file size az well.

In you file it's not different (it's not a big [1GB or more])

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: RANKX results x Slicer Results

AlexisOlson — Wed, 01 Dec 2021 23:08:09 GMT

Anonymous I checked the file and it looks to me like this is a floating-point accuracy error rather than anything wrong with the DAX.

As a workaround, you can fix the problem by rounding using INT.

Ranking categoria = RANKX ( ALL ( Folha[Categoria] ), INT ( [Vantagem] ) )

As a side note, I'd recommend using calculated columns for ranking unless the rank needs to be dynamic (which is rather common).