Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
use the measure Clients=DISTINCTCOUNT(Table[ClientI Ds] to show on graph
use the measure Clients=DISTINCTCOUNT(Table[ClientI Ds] to show on graph