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"
Anonymous's avatar
Anonymous
Not applicable
3 years ago
 
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] )))