Generate RowNumbers based on a column without any memory full error for loading the data in a visual

[Pravallika_L]

I did in the below way first to generate row numbers based on the index column, but it's working absolutely fine when filtered. But it's throwing error when i removed the filters and wanted to view complete data.

--> Visual Row = CALCULATE(COUNT( v_app_gilman_applicant[Index] ), FILTER (ALLSELECTED(v_app_gilman_applicant), v_app_gilman_applicant[Index] <= Max ( v_app_gilman_applicant[Index]) ))

--> Another way i took the max value in a variable but still it's the same behaviour. 

Row_num =

var num=maxx(v_app_gilman_applicant,v_app_gilman_applicant[Index])

return

CALCULATE(COUNT( v_app_gilman_applicant[Index] ), FILTER (ALLSELECTED(v_app_gilman_applicant), v_app_gilman_applicant[Index] <= num ))

--> I wanted to try using RANKX function but not able to see this index column. I am not sure that only measures will be used in RANKX function

Hope some one helps me on this. Any help much appreciated. Thankyou so much!!

@tamerj1 could you please help on the above measure

[tamerj1]

Hi @Pravallika_L 
Please try

Visual Row =
COUNTROWS (
    FILTER (
        ALLSELECTED ( v_app_gilman_applicant[Index] ),
        v_app_gilman_applicant[Index] <= MAX ( v_app_gilman_applicant[Index] )
    )
)