Forum Discussion
dokat
Post Prodigy
Post ProdigyCreating 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...
dokatPost Prodigy
Post ProdigyAbhinavJoshi I am still getting the same error message
EARLIER/EARLIEST refers to an earlier row context which doesn't exist.
"
AbhinavJoshi
Responsive Resident
Responsive ResidentHi, try this if earlier doesn't work for you
Index =
COUNTROWS(
FILTER(
ALL('TableName'),
'TableName'[UniqueKey] <= MAX('TableName'[UniqueKey])
)
)
- dokat
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