Using Index with Getfieldselection and 'Show measure if'

[orangebloss]

I have a chart that I'm using the show measure if formula :

index(GetFieldSelections(SevenDayTaskCompletionTimeStatus),'Complete') or GetSelectedCount(SevenDayTaskCompletionTimeStatus)=0

This works fine for most permutations (Overdue, not due etc), however I have 2 similar values - 'Complete' and 'Complete - Unknown Due Date'. It looks as though the index is returning only those with a 'Complete' status - is there a way to get it to look for a specific text string to prevent this or is there a better way to show values when they are selected (could be multiple values selected) or when nothing is selected?

When 'Complete - Unknown Due Date' is selected the chart is displaying the complete ones only:

[Kushal_Chawda · Accepted solution]

@orangebloss  try below

Index('|'& GetFieldSelections(SevenDayTaskCompletionTimeStatus) & '|','|Complete|')

[orangebloss]

Thanks @Kushal_Chawda - Seems to have done the trick!