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

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] ) )
)