Adding a Row number to a Table visual with thousands of rows

[U156531]

I have this measure below that creates a row number in a Table visual. I added an index to the query and used that index in the measure. There are thousands of rows being displayed in the visual so it takes a very long time to populate the Table visual. Is there something I can do to make this visual load faster?

Row =

CALCULATE(

    COUNTROWS('TIDDVCU'),

    FILTER(

        ALLSELECTED('TIDDVCU'),

        'TIDDVCU'[Index] <= MAX('TIDDVCU'[Index])

    )

)

[HarishKM]

@U156531 Hey,
you can follow this blog optimise report - Power BI Performance Optimization: Make Reports Run Up to 10X Faster

and you can also refer this good video on best practices in Power bi - Power BI visualization best practices by Marco Russo.

Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-venuppu · Accepted solution]

Hi @U156531 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

[rajendraongole1]

Hi @U156531  - Instead of counting rows up to the current index, use RANKX, which is optimized for ranking operations.

use calculated column as like below:

Row1 =

RANKX(ALLSELECTED('TIDDVCU'), 'TIDDVCU'[Index], , ASC, DENSE)

Hope this helps.