Forum Discussion
Advocate ITable visualization not showing measure from one table when linked to another table with no match
Advocate IYep I was able to create it - it just produces the same results as shown in the original screenshot.
Community Champion
Sorry, I didn't read your sample data carefully enough. Since you don't have all orders in the delivery table and because of the cross filter direction of your relationship, this won't work. See the attached sample file for a solution using an Orders Dimension table, which creates a distinct list of ALL order numbers. Use that for your visualizations, still set to show items with no data, and make sure to set the summarization to SUM on the order qty and Don't Summarize on the Delivery Number.
- willayd
AllisonKennedy thanks a ton for the suggestions! Unfortunately the problem still persists in the file that you shared. Note how the order_quantity is blank for order number 101 below: