In the simple method, you’ll need to distinguish the company, the country, or the team you are analyzing and all the other members of our segmentation field.
Tableau allows you to distinguish with many different possibilities: Sets, Group, Table Calculation (Percent of Total), but the solution that I found to be the simplest, and with few limitations, is an “If” row level calculation.
In this Viz, “World Happiness,” we can see the simple method where there is a defined benchmark— in this case it is country.
This Viz allows the user select a country with a parameter [Country selected], and then use this parameter in an “If” calculation to isolate the KPI value of the country selected:
This calculated field will be null if the row is not for the member you want to analyse (the country choose thanks to the parameter [Country selected]). Now, this new field can be used to benchmark the KPI of one country against all the countries. In the Viz I use this field to show the country selected KPI with a line versus all the countries, the circles: