Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello Everyone,
I have a dataset that is imported in the desktop version and includes city names and the success of a test in those cities as follows. test_success is a binary column where 1 represents success.
city | test_success |
a | 1 |
b | 0 |
c | 0 |
a | 1 |
d | 1 |
c | 0 |
b | 1 |
I would like to create a table or pie chart that shows the total number of tests held in each city as well as the proportion of success of the tests in each city, so the outcome would show three columns:
So, in this case, the percentage of success rate in each city is equal to the total number of success divided by the total number of tests in each city.
I hope someone can help me with this request.
Much appreciated
Solved! Go to Solution.
You can calculate in following way
Proud to be a Super User!
Thank you for your reply 🙂
Could you please Mark my post as a solution?
Proud to be a Super User!
You can calculate in following way
Proud to be a Super User!
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |