cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

 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:

•  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
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]

Proud to be a Super User!

3 REPLIES 3
Super User

Could you please Mark my post as a solution?

Proud to be a 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]

Proud to be a Super User!

New Member

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