Metrics table auto index number number

[RajK2]

I have created metrics table using three column description and sales values

now i need to give serial number using dax formula, pls suggest

column name like product, manager, sales amount

1

2

3

thanks

[v-agajavelly]

Hi @RajK2 

Thanks for the update and sharing the visuals. I can see what's going wrong here, the current DAX approach with RANKX over a pre-summarized table (SUMMARIZECOLUMNS) creates a static table that ignores your filters, even though it might look like it's working. That’s why you’re getting repeating index numbers or unexpected results when applying slicers, it doesn’t dynamically adjust to what's visible in the visual.

Try bellow dax to achieve filter-respecting.

Index Measure = RANKX(ALLSELECTED(Metrics), CALCULATE(SUM(Metrics[Sales Amount])), ASC, DENSE)

If you just want row numbers, you can simplify it to

Index Measure = RANKX(ALLSELECTED(Metrics),Metrics[Product],,ASC,DENSE)

This respects the filters from slicers, page-level filters, etc, and it gives you a clean 1, 2, 3, ... index with no need for RAND() or static summaries, it’s dynamic and works in visuals directly.

In case if still your index doesn’t need to change with filters, Power Query's “Add Index Column” is still the cleanest.

_________________________________________________________________________________________________________________________
If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.

Thank you,
Akhil.

[danextian]

hI @RajK2 

Assuming there are multiple tables involve, try something like below

Index Measure = 
VAR vTable =
    SUMMARIZECOLUMNS (
        'Category'[Category],
        'Category'[sort],
        'Geo'[Geo],
        REMOVEFILTERS(),  -- Fully unfilter report context
        "Total_Revenue", [Total Revenue]
    )

VAR Index =
    RANKX (
        vTable,
        [Total Revenue] + ( RAND() * RAND() ),
        ,
        ASC,
        DENSE
    )


RETURN
    Index

RAND() is not necessary but may help with breaking ties

[RajK2]

I am not getting same answer so its repiting each rows with same appears

I want simple I applied multiple filters as i need rows sequence 1,2,3,4,5 without any issues

Thanks!

[DataNinja777]

Hi @RajK2 ,

For creating a serial number, I recommend to use Power Query as the best practice, because there is often no inherent business order in a table.

Using Power Query's "Add Index Column" is the superior method because it creates a simple, static index based on the row's position during data import, without needing any sorting logic.

The DAX RANKX function, in contrast, is designed for value-based ranking (e.g., ranking sales from highest to lowest). Using it for a simple serial number is inefficient and forces a sorting logic that may not be meaningful.

Recommended Steps:

1. In the Power Query Editor, go to the Add Column tab.
2. Click Index Column and select From 1.
3. Click Close & Apply.

This approach is simpler, more performant, and better suited for this exact task.

Best regards,