Forum Discussion
Creating index column to count rows
AbhinavJoshi Its combined of 4 tables.
In that case, if you have any fact tables create and index on that, or simply add a card on the Visualization that shows the count of your ID.
AbhinavJoshi I am still getting the same error message
EARLIER/EARLIEST refers to an earlier row context which doesn't exist.
"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