How to show two table data to barchats

[sweetstar]

The current bar chat was pretty simple. Just bars, filter, slicers. The data was coming from one table connecting a database. however, I don't have the credential of the database but I can download PBIX modify, and upload back to the BPI service. 

Now, I was asked to add an extra CSV saving in SharePoint. The CSV data will be seen as a certain EventType (all row fixed with 'from smartuse') and add besides the previous 2 groups of bars. (I drew blue, green boxes to simulate)

I did check the forum. It seems that the only solution is to combine two tables into a new one. But I prefer not to do so, as I cannot apply the data model without the DB credential. Instead, I prefer using a measure. But do correct me if i am wrong.

[amitchandak · Accepted solution]

@sweetstar , You have create a new table in dax for common columns

example

event type = distinct(union(distinct(Table[EventType]),distinct(Table[EventType])))

Other in same way if need. Add date table even needed.

Join these with your two tables and analyze with common dimension