Forum Discussion
POSPOS
Post Partisan
Post PartisanIndex for each group using DAX
Hi All, I have a requiremet to get the idexes for each group of data. Please find sample data below: Note: We have other columns too in the actual data. this is only a sample data Protocol ...
vicky_
Super User
Super UserIf the Index is based on date, then you're basically looking for the count of items less than or equal to the current date for each Protocol.
This is the DAX I used:
Index = COUNTROWS(FILTER(ALL('Table'), 'Table'[Date] <= SELECTEDVALUE('Table'[Date]) && 'Table'[Protocol] = SELECTEDVALUE('Table'[Protocol])))
