Add serial number in matrix (I am using slicers too so the serial number shouldn't get affected)

[laxmikantpatil]

I have a simple set of data

I created a matrix visual

added slicers

now i want to add serial number.

How do i do this.

I tried using the below DAX code but it isn't helping. Please help

Row_Number = 
CALCULATE (
    COUNTROWS(Details),
    FILTER ( ALLSELECTED ( Details), Details[Project] <= MAX ( Details[Project]) )
)

[v-frfei-msft · Accepted solution]

Hi @laxmikantpatil ,

Please update your measure as below.

Row_Number = 
CALCULATE (
    DISTINCTCOUNT(Details[Project]),
    FILTER ( ALLSELECTED ( Details), Details[Project] <= MAX ( Details[Project]) )
)