topic Re: Keep ranking value with filter in DAX Commands and Tips

Keep ranking value with filter

Anonymous — Tue, 20 Dec 2022 10:29:15 GMT

Hello Community,

I am trying to represent the global ranking position for an entity and I get it. But when I want to show only one of the entities the ranking value becomes 1. I understand why it does this, but I don't manage to keep its actual position in the ranking even if I am filtering the visual by a single entity.

Can this be done?

Best Regards

Re: Keep ranking value with filter

johnt75 — Tue, 20 Dec 2022 11:52:32 GMT

Try

Ranking = RANKX ( ALL ( 'Dim Grupo'[GRUPO_ABREV] ), CALCULATE ( SUM ( 'Fact total'[Primas emitidas] ) ), , DESC, SKIP )

Re: Keep ranking value with filter

Anonymous — Tue, 20 Dec 2022 12:26:29 GMT

Does not work

I want to keep the original value

Re: Keep ranking value with filter

johnt75 — Tue, 20 Dec 2022 13:43:46 GMT

Are there any other columns in your table visual, as opposed to measures ?

Re: Keep ranking value with filter

Anonymous — Tue, 20 Dec 2022 14:24:12 GMT

The "Premium Ranking (Product Ranking)" is the metric with the overall ranking. The second ranking metric is the DAX metric I have attached above and finally, "Ranking (community)" is the metric that contains the code you have provided me.

Re: Keep ranking value with filter

johnt75 — Tue, 20 Dec 2022 14:34:16 GMT

Is it possible to share a PBIX with any confidential information removed ? I've tried the code I wrote against one of my models and it seems to work correctly.

Re: Keep ranking value with filter

Anonymous — Tue, 20 Dec 2022 15:44:49 GMT

I'm sorry, I'm afraid that's not possible.

If I use the metric you have provided me and if you filter by one of the categories that form "GROUPS_ABREV" the value it takes is 1 because it is the only row that is showing

Re: Keep ranking value with filter

johnt75 — Tue, 20 Dec 2022 16:20:23 GMT

Can you post the query generated for the table visual from Performance Analyzer?