Forum Discussion
Matrix Table help
derekli1700 I wouldn't recommend this approach because it is not the best practice but you can try to add a new column by concatenating the period and the store column in both Overview and Top 5 monthly tables, and then use this column to set the relationship, and I believe it will get you the correct numbers.
derekli1700 it is a surprise to see that the overview table doesn't have a customer in it. I'm unsure why you have pre-computed separate tables to get the top 5 customers. It can easily achieved using DAX with a single (overview table in your case). There are tons of blog posts on how to achieve this.
based off my current table configuration - do you have any advice on the relationship creation so that the volume value changes when i use the dropdown within the matrix table? Or is DAX needed to do that? Thanks. Would like if you could give it a shot on a test file but understand if that's out of scope for a forum answer