Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

DAX Question (Querying Data with DAX combine data from two tables)


I am new to DAX and am pulling Tabular Data from Analysis Services. There is a lot of data and I only want to pull certain columns from different tables in the cube. I can pull a couple of columns from one table but not sure how to combine it. Please see the screenshot below any help with writing this query would be appreciated.

For example, I want to see [Region] from 'Companies' and [State] from 'Houses'DAX.PNG

Super User II
Super User II

Hi @mcornfield ,


I think this is a good article for your question.


Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors