topic Rank in Card visual with filter in DAX Commands and Tips

Rank in Card visual with filter

Anonymous — Thu, 23 Feb 2023 11:51:54 GMT

Hi,

I have the below table

I have a rank formula on a card visual displaying the rank for Company 1.

rankx(all('Table'[Company Group]),CALCULATE(sum('Table'[Premium])))

Each company is split out by subsidiaries as below,

I filter for Company 1 and only for Company 1 uk and Company 1 europe the rank just gives me 1.

How do I update the formula so I can filter for the Company Names but still get the rank for Company group?

Thanks,

johnt75 — Thu, 23 Feb 2023 13:56:05 GMT

You can use

Group rank = RANKX( ALL( 'Table'[Company Group]), CALCULATE( SUM('Table'[Premium]), ALLEXCEPT('Table', 'Table'[Company Group]) ) )

Anonymous — Fri, 24 Feb 2023 13:11:56 GMT

Thanks I got the following error

johnt75 — Fri, 24 Feb 2023 14:35:14 GMT

The code I posted works for me. Can you post a screenshot of your measure?

Anonymous — Wed, 01 Mar 2023 12:09:40 GMT

have managed to get the formula to work but the rank is not updating when I select the Company Names.

Rank = RANKX( ALL( Table[Company Group]), CALCULATE(([premium]), ALLEXCEPT('Table',Table[Company Group] )))