RANKX always returns 1, ranking by the how often value appears in column

[Anonymous]

I want to give a rank each [OpenAnswer] in responses by how often each value of responses[OpenAnwer] appears in the column. 

Example:

OpenAnswer

A

B

B

C

C

C

A should get rank 3, B rank 2, and C rank 3

So far I've tried these and all returned 1 for each entry

MeesteOV = 
VAR SelectedA = SELECTEDVALUE(responses[OpenAnswer]) 
RETURN
RANKX(ALLSELECTED(responses), CALCULATE(COUNTROWS(FILTER(ALLSELECTED(responses), responses[OpenAnswer] = SelectedA))),,desc, Skip)

-------------
MeesteOV = 
RANKX(ALLSELECTED(responses), CALCULATE(COUNTROWS(responses)),,desc, Skip)

---------------
MeesteOV = 
RANKX(ALLSELECTED(responses), CALCULATE(COUNT(responses[OpenAnswer)),,desc, Skip)

[amitchandak]

@Anonymous , what are the columns you are using in visual?

Try like

MeesteOV =
RANKX(ALLSELECTED(responses[OpenAnswer]), CALCULATE(COUNT(responses[OpenAnswer)),,desc, Skip)

this will rank of OpenAnswer and will group inside any other non summarized column, say you use OpenAnswer_id then you will get rank =1 and there is one OpenAnswer inside OpenAnswer_id

[Anonymous]

ALLSELECTED gave problems with a page level filter and I managed to use your code to make this:

MeesteOV = 
IF(
    ISBLANK(SELECTEDVALUE(responses[OpenAnswer])), 
    BLANK(),
    RANKX(ALLSELECTED(responses[OpenAnswer]), CALCULATE(COUNT(responses[OpenAnswer])),,desc, Dense)
)