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

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

Anonymous if i understood you correctly, go to power bi desktop query editor,

 

under Add Column tab click Add index column.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

No ankitpatira.

 

Thiz what i get when I try to use index Column which in fact is a static value for every row:

Vis Filters: ScenarioName = 'Budget' for Table1

                  ScenarioName  = 'Actual and Forecast' for Table2 .

 

But I need Outpu like this:

ScenarioName   Index1                   ScenaroName   Index1

 Budget                 1                          Forecast              1

                                                          Actual                 2

I want Index to be start from 1 in Every table for index column which in the sence must be a dynamic calculation which gives valuse from 1 to n every time we use it (like row number in (Cognos and SSRS).