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

Anonymous — Fri, 05 May 2023 05:43:23 GMT

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

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

tamerj1 — Fri, 05 May 2023 06:20:34 GMT

Hi Anonymous
Please try

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

topic Re: Generate RowNumbers based on a column without any memory full error for loading the data in a visual in DAX Commands and Tips

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

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