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

[mcornfield]

Hello,

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'

[mwegener]

Hi @mcornfield ,

I think this is a good article for your question.

https://www.red-gate.com/simple-talk/sql/reporting-services/using-dax-to-retrieve-tabular-data/