Problem using set expression during filtering

[user467341]

Hi all,

I have a set expression:

=IF(ISNULL(Aggr(Only({<[DIM_WS.Desc]-={"*REMOVAL*"}>} DIM_WS.Desc), DIM_WS.Desc)), DIM_SM.SM_Desc, Aggr(Only({<[DIM_WS.Desc]-={"*REMOVAL*"}>} DIM_WS.Desc), DIM_WS.Desc))

When I clicked on my dimension column to filter, which is the "Desc" in my pivot table, the return result is two filters, one coming from DIM_WS table and the other DIM_SM table.

My set expression idea is to omit the data with REMOVAL in DIM_WS table, and get the data out. If DIM_WS.Desc column is NULL, then it will get the data from DIM_SM.

Because of this two filtering, my table is not getting properly filtered.

Is it possible to modify my set expression so that it only return one filter selection from either tables?

[vinieme12]

Filtering on Calculated Dimension will ALWAYS filter on ACTUAL Dimensions used in AGGR()

I would suggest creating an actual field during data load

[neerajthakur]

Join the two table and then apply this logic.