The use case is for Human Capital Planning, specifically succession planning - A company will have a plan for each employee to have a successor (s) which can be 9 names sometimes they repeat names because each input for the successors does have other uses. So the aim is to count how many unique successor (s) there are.
There is the potential to have the relevant line items become a dimension to use but I wasn't sure which formula to then use to achieve the unique count - now i'm speaking about the problem I feel like I have an idea! I guess you could use the first occurrence formula and then count on the results of it but it needs to apply to each row of data not the transaction list - Question will firstoccurrence apply to the subset list only? (i will test)
I'm going to test this out and come back to you!
Sometimes thinking about your issue and describing it in detail can make your realise what to do!
Re: Best way to identify unique text across 9 repeating text line items across and count
I created a module dimensioned by the 9 line items as a list and referenced the 9 line items to the list from the source module and used first occurrence along the 9 line items dimension to get the number of unique names.