Row Number RANKX ALL DimProduct EnglishProductNameDimProduct Color Internet Sales You can have multiple columns inside the ALL function. How to add new row data in power bi Step 1. Row Number By Group Step 1.
Hit the enter key.
In the Power BI service that means opening the report and selecting Edit from the menu bar as shown in the following image. Now to Number rows by Group In order to number rows by group what we really want to do is add an Index column but we need to add it for each of the individual tables in our grouped segments. The following measure definition presents an example. Sales Orders COUNTSalesOrderDate Providing that the granularity of the Sales table is one row per sales order and the OrderDate column does not contain BLANKs then the measure will return a correct result.