How can I join tables using only DAX

Question

How can I do it by using DAX only?

- No usage of SQL code!
- The relationship between tables is established in VS 2010 with an SSAS instance in tabular mode.

Answer 1

You can see this below example:

 FILTER('InternetSales_USD' , 'InternetSales_USD'[SalesTerritoryKey]<>1 && 'InternetSales_USD'[SalesTerritoryKey]<>2 && 'InternetSales_USD'[SalesTerritoryKey]<>3 && 'InternetSales_USD'[SalesTerritoryKey]<>4 && 'InternetSales_USD'[SalesTerritoryKey]<>5)