Table view : The rows are filtered when i add the column from other table

[vnqt]

Hi , 

I have the same problem as this post. https://community.fabric.microsoft.com/t5/Desktop/When-Adding-column-from-other-table-it-filters-my-...

I have a table view which contains the columns of 2 different tables. 

When I add the columns of the second table, the rows of table one are filtered. I chose the option 'Show item with no data', It only works when I move all the columns of second table to the end 

Could you please help ?

Thank you 

Tg

[lbendlin · Accepted solution]

That is likely working as designed - read about expanded tables. Expanded tables in DAX - SQLBI

[vnqt]

Thank you for your reply.