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

  • RasikaOgale's avatar
    RasikaOgale
    Frequent Visitor
    9 years ago

    I also want to apply same in my project. I have created Index column and then applied mentioned formula, but isn't work. 

  • elads's avatar
    elads
    Icon for Helper III rankHelper III
    6 years ago

    Hi Anonymous ,

     

    I tried to use your formula, but unfortunately it doesn't work (See attached image)

     

    I am also attaching your formula, maybe I was wrong about something.

    DynamicRowNumber =
    CALCULATE (
    count ( A_B[Index] ),
    FILTER ( ALLSELECTED ( A_B ), A_B[Index] <= MAX ( A_B[Index] ) )
    )
  • 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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    When i use this DAX to generate Current row number getting the error below when i added the measure to the table .please help me any ideas!

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Can you please explain the logic you wrote in this measure?

    Thanks in advance:manhappy:

  • Anusha1Anusha's avatar
    Anusha1Anusha
    New Member
    3 years ago

    Hi Herbert,
    Is there a method to have this dynamic indexing calculate in columns as it is not supported to lookup values from the prior index of the  column?
    Thanks,
    Anusha 

  • ChielFaber's avatar
    ChielFaber
    Icon for Super User rankSuper User
    2 years ago

    Just found this solution while searching the forums. Works perfectly for me. Many thanks!