avoid filtering of date table when selected 'Items with no data'

[mahenkj2]

I have a date table with one-to-many relathionwhip with Order table. Order table have one to many with Invoice table.

Not all the orders have invoices, so I would like to see orders with and without invoices in one table visual. This I achieve by selecting 'Items with no data' as below:

but this eventially shows dates from datetable where there is no orders as well. 

Sample .pbix file is attached.

https://drive.google.com/file/d/1XVRBSdGLoWuv7krMCBpHA6JS8N6-WUsJ/view?usp=sharing

I need all orders with and without invoices.

All support appreciated.

[amitchandak]

@mahenkj2 ,In such case it is better to have a Dimension/Master table for Invoice ID and join it back to you table and then use this option

[mahenkj2]

Hi @amitchandak ,

Thanks. Do you mean creating a unique InvoiceID master and connect it to invoice table?

If so, that does not make any difference.