Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Rank in Card visual with filter

Hi,    I have the below table   Company Group Premium Company 1      4,102,813 Company 2    132,970,639 Company 3 46,137,791   I have a rank formula on a card visual displayi...
"DAX"
"MEASURE"
"RANKX"
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You can use

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