Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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
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.
User | Count |
---|---|
96 | |
87 | |
78 | |
73 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |