Skip to main content
Showing results for 
Search instead 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

Regular Visitor

How do I create a percentage ratio using two tables?

Hello, I'm new to the world of Power BI and I'm facing a challenge.


I'd like to analyze the complaint ratio for each customer and visualize it in a nice pie chart. I have two tables at my disposal, where each entry contains a customer number and a year in one table representing orders and complaints in the other table.

In the pie chart, I want to display the percentage of complaints relative to orders for the same time period. The lists COUNT_Complaint and COUNT_Orders have the same structure. I'd also like to be able to filter by customers and year.


I already am able to calculate the overall complaint ratio and, after filtering for individual customers, using a measure (Measure 1 = COUNTROWS('COUNT_Complaint')/COUNT_Orders*100), but I'd like to view them all simultaneously in one chart.

Thank you very much for any help!Power BI.PNG


Helpful resources


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.