Filtering with special condition

[b737]

I have data model where is possible to enter from one dimension several members at same time (two tables with relationship 1:n, Product1 is possible to have Detail_Product1 and  Detail_Product2). So now I want to filter data so to choose all products which does not have Detail_Product_id=1 and to remove it. Problem is that for Product_ID=1 I have for the same time and Detail_Product_id=1 and Detail_Product_id=2, and  report studio keep giving me back and this Product1.

How to create filter or something else that will remove Product1 because it has Detail_product_ID=1.

I use DMR

Thanks

[bdbits]

To be honest, I am not really clear on the data structure. Can you explain the dimension hierarchy? I thought maybe it was like

[Product1]
--[Detail_Product1]
--[Detail_Product2]

and your issue was if you filtered [Detail_Product2] you were still seeing [Product1], but that would make sense. Do I have the hierarchy or something all wrong?

[sdf]

As to what i understood with your post. It will return Product1 since it has both detail_product ID 1 and 2. It will only remove products that dont have Detail_product ID 1.

???