Forum Discussion
Advocate IIOrder / invoice data modelling
Advocate IIThank you for your reply v-qiuyu-msft.
Scenario:
- An order is placed and appears in the 'orders' table.
- The 'order' table contains the customer and item codes.
- This order has not yet been invoiced yet so there is not a line in the 'invoices' table with a related order number.
- Therefore, in this data model, there is no relationship between this row of the 'orders' table and the 'customers' and 'items' dimension tables.
What is the best way to get the customer and item dimensions for this order? Is a better data model structure possible?
To get around this (for now), I have used LOOKUPVALUE but it doesn't work unless I turn off some bi-directional filtering. Is that normal? Why does LOOKUPVALUE get affected by filtering?
Community SupportHi emarc1,
You can follow these two links to do data modeling:
https://www.red-gate.com/simple-talk/sql/bi/power-bi-data-modelling/
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-create-and-manage-relationships/
Looupvalue() function should work well with both cross filter. If you don't turn off it, is there any error throws out when you use Lookupvalue() function?
Best Regards,
Qiuyun Yu