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...
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.
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.
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).