13 Replies Latest reply on Oct 25, 2013 5:19 AM by Prashant Sharma

    Find count of values selected in Filter

    Anisha Nair

      I have a multi-select checkbox Country filter. In a tabular chart on the same dashboard, I need to display measure A as per below:

      • If only ONE country is selected in filter, show measure A for the selected Country.
      • If More than ONE country is selected, display measure A = "NA" or 0

       

      For such a scenario, how can I create a calculated field to find the "Count" of countries selected on the basis of which I can manipulate measure A display?

       

      Workbook with sample data attached