if all selection in filter pane

[livio218526]

Hi everyone,

I have a problem. I want to create a measure that show me a text 'WW' when i selected all value from a filter pane and concatenate ' | ' and another dimension like this:

     TEST | TEST1

my function is:

=if([MGMT_REPORT.Region]='APAC' AND [MGMT_REPORT.Region]='EMEA' AND [MGMT_REPORT.Region]='NAFTA' AND [MGMT_REPORT.Region]='LATAM','WW',[MGMT_REPORT.Region]) & ' | ' & [MGMT_REPORT.Month]

but it doesn't working.

If i selected ALL value for Region and Dec for Month, so i want --> WW | Dec, instead of if i selected APAC as region, i want APAC | Dec

Please help me,

Thanks,

Livio

[Chanty4u]

try

=Aggr( Concat( DISTINCT Month,'| '), IF(condition)

[Chanty4u]

try

=if([MGMT_REPORT.Region]='APAC' AND [MGMT_REPORT.Region]='EMEA' AND [MGMT_REPORT.Region]='NAFTA' AND [MGMT_REPORT.Region]='LATAM','WW',[MGMT_REPORT.Region]),Aggr( Concat( DISTINCT Month,'| ')

[livio218526]

No,  I want

Region | Month

But your function doesn't working. My function work but only if I don't selected all value.

[livio218526]

No, it is wrong

[OmarBenSalem · Accepted solution]

Maybe this scenario:

If I don't select contributeur or select them all;

I'd have this:

If I select contributeurs, I'll have this:

the expression of the text box to do this is: (try to adapt it to ur data)

if(count(distinct Contributeur)=count(all distinct Contributeur) or len(GetFieldSelections(Contributeur))=0,

'All '&' | '& concat(distinct [Activité],' '),

Concat(distinct Contributeur,' ')&' | '&concat(distinct [Activité],' ')

)

[livio218526]

Thank you it's work correctly!!