Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Dynamic Row Numbers

Hello All,   Is there anyway to get Dynamic Row Numbers with a single column in every table. For Ex: I have 2 Table viz with following data every table has viz level filters so that i am showing ...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    Anonymous

     

    You can first add an index column and then create a measure with following formula to get the dynamic row numbers.

    RowNum = 
CALCULATE (
    COUNT ( Table1[Index] ),
    FILTER ( ALLSELECTED ( Table1 ), Table1[Index] <= MAX ( Table1[Index] ) )
)

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Anonymous

 

You can first add an index column and then create a measure with following formula to get the dynamic row numbers.

RowNum = 
CALCULATE (
    COUNT ( Table1[Index] ),
    FILTER ( ALLSELECTED ( Table1 ), Table1[Index] <= MAX ( Table1[Index] ) )
)

 

Best Regards,

Herbert

jl20's avatar
jl20
Icon for Helper IV rankHelper IV
9 years ago

This doesn't work when sorting by a numeric measure (revenue, in your example). The formula does limit the numbers from 1 to number of displayed rows, but the Row numbers are not dynamic... Any ideas on how to fix?