Merge count from two different tables

[jps_HHH]

Hi all,

I have a PBI file connected to two different databases. 

However, this databases are similar columns but one database is filled in by mechanics and other by quality control.

For instance:

Database 1:  Columns "Part Number"  "Fail Description" 

Database 2:  Columns "Part Number"  "Fail Description"  

The information is not duplicated. IF a mechanic observes a fail, record it. But if a quality person observes a fail reported too.

I would like to put a graph with the "part Number" with more fails and a table with the Part number and the description.

I think that I should create a new column that includes all lines from database 1 and 2. Is that right ?  

[Deku]

I would union the table. So you would have something like

• PartNumber
• FailureReportDate
• FailureReportingSource
• Description

Then can easily sum\count and slice by the identifier of the failure