Forum Discussion
Apply a filter across mutliple tables
Hi All, I have a faily standard sales model developed that has customer, product, sales rep etc dims, and lastly a "region" dimension. The company is seperated into regions, and for each regi...
Here is a small sample of what I'm trying to do. So basically when a "region" North is selected, I need th region="North" applied to all the other dimensions and facts.
Add the dimensions to the fact table (Sales) with the below DAX script and use them in the visuals,
E.g.,
Sales Rep_Related = RELATED('Sales Rep'[Sales Rep])
Hope it will help you.
Thanks for your response, however I'm not sure that this will work, as this is just going to lookup on an existing relationship, where it's being abel to create all the relationships that is the key constraint.
Okay. Let's try this.
- Create a count measure in the fact. E.g. Count_M = COUNT(Sales[SalesId])
- Add this measure as a visual level filter in the slicers and apply Count >= 1
Please mark it as the solution if this works. Appreciate your kudos.