Apply a filter across mutliple tables

Question

Hi All,&nbsp;I have a faily standard sales model developed that has customer, product, sales rep etc dims, and lastly a "region" dimension.&nbsp;The company is seperated into regions, and for each region there is a unique set of customers,products etc.&nbsp;I am trying to work out a way that when a region is selected all the customers,products and other dimensions will be filtered by this region.&nbsp;I can't use "both" ways cross filters, as I have multiple facts which makes this ambigious, and I also don't want the behaviour of filtering to only what's in the fact tables.I also can't use a one-way relationship, as the region table need to link to the fact, and this also causes ambigious paths.&nbsp;Does anyone know of a technique that when one or more regions are selected (via a slicer or filter) that filter gets applied to all the dimensions, so customer where region_id = "North", material where region_id = "North", sales_rep where region_ID = "North".&nbsp;Thanks,&nbsp;edit: Here is a simple model that shows what I need to do.&nbsp; Basically filter all tables by region when one or more regions are selected.&nbsp;

sivamani · Answer

GaryH,&nbsp;Can you share your model diagram for better understanding?

garyh · Answer

Here is a small sample of what I'm trying to do.&nbsp; So basically when a "region" North is selected, I need th region="North" applied to all the other dimensions and facts.&nbsp;&nbsp;

sivamani · Answer

GaryH,&nbsp;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])&nbsp;Hope it will help you.

garyh · Answer

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.

sivamani · Answer

Okay. Let's try this.&nbsp;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 &gt;= 1&nbsp;Please mark it as the solution if this works. Appreciate your kudos.&nbsp;

Forum Discussion

Apply a filter across mutliple tables

7 Replies

Related content

Filter dynamically based on mutliple values

Working with mutliple nested notebooks

mutliple time format issue

Table highlighting/filtering across mutliple pages

Filter