Calculated column based on selections in check box filter

[Arvind Kumar]

I will try and explain my question through an example.

 

In my filtering scheme, I have a check box filter with 5 continents (A, B, C, D & E). Each continent has x number of countries. However, there is one country which is part of two continents (A & C). Now, I want to create a calculated column which divides the data for this country by 2 if BOTH continents A & C are selected in the check box filter in order not to double count the data. Is this possible

 

Thanks in advance!

[Gaia Paolini]

A calculated column does not react to filters.

But if you want to know the count of unique countries per continent, a simple KPI with value=UniqueCount([Country]) would work.

Otherwise please can you elaborate on what you wish to calculate and how you want it displayed.

[Arvind Kumar]

Thanks for your response Gaia. I will elaborate on the example.

 

Country Z is part of continents A & C. It has a population of 1000.

 

In my data table of all countries, country Z is showing population of 2000 instead of 1000 when I select both continents A & C.

 

I want to set a rule which says "if continents A & C are selected, population of country Z should be divided by 2, else show as is. For all other countries show population data as is."

[Gaia Paolini]

sorry, still not sure. When you say 'showing population' where does this population show A table would show each row with the correct population, even if it appears in multiple rows. Can you please show a snapshot of what you are aiming to display

[Arvind Kumar]

The data table is showing double the population count just for this country when both continents are selected. I want to solve for this.

 

Am unable to share a snapshot here.