RankX by group occurrance
I have a table below and am trying to rank order each occurrence of change in Responsibility using a calculated column. As you can see, the code is counting 1 for each instance of a unique occurrence of a Responsibility (so the first time "PCR" appears, it says 1, the second time, 2, etc., and the first time "Enroller" appears, it says 1, the second time, 2, etc...) Here's the DAX generating this result: RANKX( FILTER( ALL(LOA_Logs), LOA_Logs[LOA_UID] = EARLIER(LOA_Logs[LOA_UID]) && LOA_Logs[Responsibility] = EARLIER(LOA_Logs[Responsibility])), LOA_Logs[Index per LOA], ,ASC,Dense) Instead, what I'd like it to generate is a unique index each time the Responsibility changes. So ideally, this table would return the numbers in green. Each rank changes as the Responsibility changes. Any help would be appreciated. Thank you so much!
