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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Vlapena
New Member

Creating a summary table from 2 table summaries each from separate data sources

Hi I'm working on a report to measure the ratio of tickets with issue over total tickets processed.  These 2 values are coming from 2 different data sources.  I was able to create a weekly summary of the tickets with issue and a summary for the total tickets processed.  How do I create a summary table showing the ratio of total tickets issued over the total tickets processed?  Appreciate 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
3 REPLIES 3
amitchandak
Super User
Super User

Vlapena
New Member

Here's the data I generated in excel.  

Vlapena_0-1663812978716.png

Total Tickets is from one data source and Tickets with issue is from another data source.  The bottom table is the ratio of the 2 tables.  How can I do this in Power BI?  

Thank you for your inputs. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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