Line Number in Table

Bryanna , Hi, you may try 

Row Number = 
RANKX(
    ALLSELECTED('Order Rank'),
    'Order Rank'[Order Number],
    ,
    ASC,
    DENSE
)

I keep receiving this error but there are no duplicate order numbers in the table.

A single value for column 'Order Number' in table 'Order Rank' cannot be determined. This can happen when a measure or function formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Plase clarify if you are looking for a calculated column (a static thing) or a measure (dinamic thing). Assume you are looking for a measure but just to be sure. 

More importantly, please provise a sample of the table and a clear explanation of what you want to rank: you want to rank the order nr in an asceding way? And you want the ranking to be based only on the visible values in the matrix?

And what is the issue you have with your formula in use?

Best

FB

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