Forum Discussion

mahenkj2's avatar
mahenkj2
Icon for Solution Sage rankSolution Sage
2 years ago

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

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.

2 Replies

  • 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's avatar
      mahenkj2
      Icon for Solution Sage rankSolution Sage

      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.