6 Replies Latest reply: Mar 7, 2018 3:25 AM by Livio Sebastiano Colombo RSS

    if all selection in filter pane

    Livio Sebastiano Colombo

      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,