Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Pravallika_L
Helper I
Helper I

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

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 ))
 
Pravallika_L_0-1683265215038.png

 

 
--> 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
1 REPLY 1
tamerj1
Super User
Super User

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] )
    )
)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.