Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
new_learner
New Member

Aggregation of data by calculating percentage in each category

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.

citytest_success
a1
b0
c0
a1
d1
c0
b1

 

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:

 

  •  city
  • total number of success 
  • percentage of success rate in each city

 

 

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

 

1 ACCEPTED SOLUTION
sayaliredij
Super User
Super User

You can calculate in following way

 

Total Tests = COUNT('Table'[Test_Success])
 
Success Test = SUM('Table'[Test_Success])
 
% success = [Success Test]/[Total Tests]




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
sayaliredij
Super User
Super User

Thank you for your reply 🙂 

 

Could you please Mark my post as a solution?

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




sayaliredij
Super User
Super User

You can calculate in following way

 

Total Tests = COUNT('Table'[Test_Success])
 
Success Test = SUM('Table'[Test_Success])
 
% success = [Success Test]/[Total Tests]




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@sayaliredij It worked well, thanks so much and have a good day!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.