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

[Vlapena]

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 

[amitchandak · Accepted solution]

@Vlapena , You need to show them against common dimensions

refer

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

[Vlapena]

Here's the data I generated in excel.  

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. 

[amitchandak]

@Vlapena , Add both of them as tables, Unpivot to get a week on rows. Create common dimesions

Power Query- Pivot, Unpivot Data: https://www.youtube.com/watch?v=FUaGQBG5YnI&list=PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki&index=3

refer

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...