Show Measure if selected in filter

[orangebloss]

I'm wanting to show a value in a chart if it is selected in the filter or if nothing is selected.

I have tired using:

(GetFieldSelections(SevenDayTaskCompletionTimeStatus) ='Complete - No Due Date') or GetSelectedCount(SevenDayTaskCompletionTimeStatus)=0

and

wildmatch(GetFieldSelections(SevenDayTaskCompletionTimeStatus),'Complete - No Due Date'')

or GetSelectedCount(SevenDayTaskCompletionTimeStatus)=0

These work if only one option in the filter is selected, but if I wanted to show both 'Complete' and 'Complete - No Due Date' then it returns an error

:

Advice on how to get it to show if it's selected appreciated!

[MatheusC]

Hi, 

@orangebloss, For me this solution worked well, test it in your case.


if(Concat(DISTINCT YourField, ', ') = Concat({< YourField *= {'Value1', 'Value2'}>}DISTINCT YourField, ', '),1,0)

- Regads, Matheus

[Chanty4u · Accepted solution]

Try this 

If(

    GetSelectedCount(SevenDayTaskCompletionTimeStatus) = 0 

    OR WildMatch(Concat(SevenDayTaskCompletionTimeStatus, '|'), '*Complete*'), 

    YourMeasure

)

[orangebloss]

Absolutely perfect! Thanks!