How to apply filters to only one table (without using Alternate States or Load Script)?

[NewUser999]

Hello,

I have a sheet with two tables. Both tables contain only dimensions (both tables contain completely different dimensions). I would like to filter by dimension on table one without filtering table 2. I have a few problems:

1. I can't use Alternate States because of company policy.

2. I can't change the load script.

I know you can use sum ({1}Value) or sum ({<Value=>}), but the problem is that I don't have any aggregations (just a list) and am only filtering on dimensions. Any solutions? Thanks

[Primrose]

@NewUser999 , it's not what you're looking for, but you may try adding one of the dimensions as a measure. Something like that:

Concat({<FilterToBeExcluded1=,FilterToBeExcluded2= >}the dimension)

You may choose Total function: None to remove the totals, so for the users, it will look like a normal column. However, they will not be able to filter that dimension directly from the table, because it's a measure indeed.

Hope this helps.