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

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.

    • SivaMani's avatar
      SivaMani
      Resident Rockstar
      5 years ago

      In that case, I don't think of any other solutions except RELATED. RELATED should work for your model (assuming based on the screenshot you posted).