Forum Discussion

GaryH's avatar
GaryH
Frequent Visitor
5 years ago

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...
Need Help
GaryH's avatar
GaryH
Frequent Visitor
5 years ago

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.

 

 

SivaMani's avatar
SivaMani
Resident Rockstar
5 years ago

GaryH,

 

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.

  • GaryH's avatar
    GaryH
    Frequent Visitor
    5 years ago

    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's avatar
      SivaMani
      Resident Rockstar
      5 years ago

      Okay. Let's try this.

       

      1. Create a count measure in the fact. E.g. Count_M = COUNT(Sales[SalesId])
      2. 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.

       

      • GaryH's avatar
        GaryH
        Frequent Visitor
        5 years ago

        Thanks once again Siva. 

         

        I did come across this as a solution if I were using slicers, however my reports are using "all pages filters" as there are far too many filter possibilities for slicers to work.   Unfortunately, unlike slicers, filters don't have a "vlsual level filter".  So, this isn't going to work for me.