Forum Discussion

ShmuelM's avatar
ShmuelM
Advocate II
9 years ago
Solved

How to add a Serial Row Number Column in Power BI Table / Matrix visual?

Hi is there a way to do that , just to add the row number that will regenerate every time the table changes? 
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi ShmuelM,

     

    Grabbing in your table just add a measure with the countrows:

     

    Row_Number = 
CALCULATE (
    COUNTROWS(Profit_Table),
    FILTER ( ALLSELECTED ( Profit_Table ), Profit_Table[Position] <= MAX ( Profit_Table[Position]) )
)

    As you can see in the print below it counts the number of rows no matter if you have slicer or not, left table is the full data, right table is influenced by slicer.

     

     

    Please be aware that this measure is influenced by the order of your Position so if you want to order by another column this will give you the row number in a different order also.

     

    Regards,

    MFelix

     

     

MFelix's avatar
MFelix
Super User
3 years ago

Hi marksn ,

 

In this case you need to make your based on a virtual table created on that specif calculation, that is based on your selections.

marksn's avatar
marksn
Frequent Visitor
3 years ago

Hi Miguel,

Thanks for the response. Do you know of an easy way to create a virtual table based on a table visual with multiple table & measure as source of columns? I reckon it can be done by copying the Performance Analyzer Query?