Dynamic row numbering in Table visual based on filtered value

Hi,

I wanted to have serial number to be created dynamically in the PowerBI dashard for the Table visual. There are 3 Filtered defined :

1. District

2. Block

3. Mobile users

The Report ->Table get the data from 2 diffirent Data ->Tables based on the values selected through in the above defined filters (Report-> Slicer).

It is working perfectally fine. However, we may also need to have a serial number for each of the displaying records:

Data Tables are linked through users_id :

Table#1 : pbi_dentified_locations : district, block and Subcenter

Table#2 : pbi_dentified_and_followup : All values being referred except the above 3 values.

I tried it by applying the below measures, where i got an index column created in Table#2.

CALCULATE (

COUNTROWS(pbi_identified_and_followup),

FILTER ( ALLSELECTED ( pbi_identified_and_followup ), pbi_identified_and_followup[Index] <= MAX (pbi_identified_and_followup[Index]) ) )

But getting error as "Visual has exceeded the available resources".

I also would like to share that, the number of records are high (10000+) in the above tables and it keeps increasing in the coming days.

Please guide me on this.

Thanks in advance.

Gurudayal Sahu

Forum Discussion