Forum Discussion
Creating index column to count rows
Hi I have a .pbix file from direct query data feeds from axure server. I created a report using four tables that are linked in the back end. The name of the tables are Activity Status, Group, F...
Hi, try this if earlier doesn't work for you
Index =
COUNTROWS(
FILTER(
ALL('TableName'),
'TableName'[UniqueKey] <= MAX('TableName'[UniqueKey])
)
)
AbhinavJoshi this only returned number of rows in Parent Customer table. One customer may show up multiple times in the report because they can carry multiple product line.
Please see below example. Walmart carries 200 different product lines because of that show up 200 times in the report. However above formula only return unique count of customers in " Parent Customer" table. I am trying to find out total number of rows (basically number of customer product combinations)
Hope this makes sense
| Customer | Item |
| Walmart | 101 |
| Walmart | 102 |
| Target | 101 |
| Kroger | 103 |
| H-E-B | 103 |
| H-E-B | 104 |