Forum Discussion
Matrix Table Displaying Blanks
Hi All, I have a matrix table visual where I have dropped in my Suppliers to the rows to see which ones have accounted for Deliveries. But the entire list is showing (blank values as well as two with...
Hi Rita, I just discovered the main issue. The Supplier Table is connected to the Product Deliveries Table via Supplier Name, but the Supplier Names don't exist in the Product Orders Table. So when I drag the Suplier Name to the Matrix table, it's not matching it to any corresponding names in the Product Orders table, therefore displaying all the suppliers with or without delivery values. That's the issue. So now, I wonder if there's a measure I can write to filter out the Suppliers from the Product Deliveries table who don't have deliveries for a given date range. Does that make sense. Thanks.
