Metric views joins

[Akshatkumar69]

I am currently working on a migration project from power BI to ai bi dashboard in databricks . Now i am using the metric views to create all the measures and DAX queries which i have in my power BI report in YAML in the metric views but the main problem is as in power bi  we ca select the columns from multiple tables but the same this i cant do in databricks as we can only select a single datasource while creating a chart . 

Let me give you an example suppose i have sales table and a  product table and there are two columns from the both the table in power bi but to do the same thing metric views i cant do it , as either i can select my sales table or my product table .

for example this you can refer to One is from sales by state one is from sales by maker .