Forum Discussion

Bryanna's avatar
Bryanna
Helper II
1 year ago
Solved

Line Number in Table

Hi,   Looking for some help! I need to add a line number to a table in PBI, however, everything i try is too slow to populate even when i have it filtered with just a handful of options. I created ...
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi Bryanna ,

    Thank you for your response. Please share sample PBIX file. It will help me to replicate the scenario.

     

    Regards,

    Dinesh

v-dineshya's avatar
v-dineshya
Community Support
1 year ago

Hi Bryanna ,

Thank you for reaching out to the Microsoft Community Forum.

 

You are trying to create a dynamic row number in Power BI when filter in the report based on "Order  Number".

 

Please follow below steps.

 

1.  I have created table "Table" based on your sample data. refer snap.

 

 

2.  Created measure "Row Number" with below DAX , it will create dynamic row number.

 

Row Number =
CALCULATE(
    COUNTROWS(
        FILTER(
            ALLSELECTED('Table'[Order Number]),
            'Table'[Order Number] <= MAX('Table'[Order Number])
        )
    )
)
 
3.  Please refer output snap and attched PBIX file for your reference.
 

 

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.  Please do let us know if you have any further queries.

 

Regards,

Dinesh

 

 

v-dineshya's avatar
v-dineshya
Community Support
1 year ago

Hi Bryanna ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Thank you.

  • v-dineshya's avatar
    v-dineshya
    Community Support
    1 year ago

    Hi @Bryanna ,

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

     

    Thank you.

    • Bryanna's avatar
      Bryanna
      Helper II
      1 year ago

      Apologies on the delay. We ended up having to do a new visual calculation and entered a 1 and then did a runningsum calculation off of that. The only stipulation is there is no total at the bottom.

       

      What you had provided worked for a small number of entries but due to the amount of data in the pbi , it wouldnt work for this scenario.

       

       

      • v-dineshya's avatar
        v-dineshya
        Community Support
        1 year ago

        Hi Bryanna ,

        Thank you for your response. Please share sample PBIX file. It will help me to replicate the scenario.

         

        Regards,

        Dinesh