Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |