How to count number of distinct users on a chart?

[ibrahimsharaf]

Hello, if my Table looks like this:

Client IDs     Country

ADS1            USA

ADS2            USA

ADS1            USA

If I want to create a stacked column chart, Country on the X Axis, Number of Visitors (Distinct Clients IDs) on the Y Axis, so it should show that USA has 2 visitors only not 3, as "ADS1" is repeated twice, how can I solve this problem?

[SergeiStPete · Accepted solution]

use the measure Clients=DISTINCTCOUNT(Table[ClientI Ds] to show on graph