Forum Discussion
willayd
Advocate I
Advocate ITable visualization not showing measure from one table when linked to another table with no match
I have a model that links orders to deliveries. For the sake of sample data, we can reproduce this model using the following DAX table constructors: order = DATATABLE("order_number", INTEGER,...
AllisonKennedy
Community Champion
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.
willaydAdvocate I
Advocate IAllisonKennedy 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: