How to Create a New crossjoin table with filter

Question

I am trying to create a new table with crossjoin for table2 and table3 but based on a filter which is A. Similar to the example below.&nbsp;table1&nbsp; &nbsp; &nbsp; table 2&nbsp; &nbsp;table 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; New TableA&nbsp; |&nbsp; B&nbsp; &nbsp; &nbsp;A | C | ids&nbsp; &nbsp; &nbsp; A | ids&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C&nbsp; &nbsp;|&nbsp; ids | A______&nbsp; &nbsp; &nbsp;_________&nbsp; &nbsp; &nbsp; _______&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; _____________p&nbsp; | a&nbsp; &nbsp; &nbsp; p | x | 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; P | 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp;|&nbsp; 1&nbsp; | pq&nbsp; | b&nbsp; &nbsp; &nbsp; p | x | 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; P | 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp;|&nbsp; 2&nbsp; | pr&nbsp; &nbsp;| c&nbsp; &nbsp; &nbsp; p | y | 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p | 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp;|&nbsp; 3&nbsp; | ps&nbsp; &nbsp;| d&nbsp; &nbsp; &nbsp;p | y | 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; q | 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp;|&nbsp; 4&nbsp; | qt&nbsp; &nbsp;| e&nbsp; &nbsp; &nbsp; q | x | 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; q | 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp;|&nbsp; 5&nbsp; | q&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; y&nbsp; &nbsp;| 1&nbsp; | p&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;y&nbsp; &nbsp;| 2&nbsp; | p&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;y&nbsp; &nbsp;| 3&nbsp; | p

amitchandak · Accepted Answer

SrinathLM10 , logic or cross join in nor very clear. You can merge in power query Using Column A. In DAx You can do inner join. 
&nbsp;
Refer https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
&nbsp;
Let us know for last table

Forum Discussion

How to Create a New crossjoin table with filter

2 Replies

Related content

Crossjoin measure with filter

Crossjoin and then summarize

Crossjoin with filters

Creating a Date Filter in Power BI

DAX - Crossjoin with Criteria