Report Level Filtering based on a condition based of two columns

[Anonymous]

Hello 

I have columns like WareHouse, Plant, Storage Type, Storage Bin in one table and i built report on top of this table with a slicer on warehouse.

.

The filtering requirement is as below -

If warehouse selected is not null, then Storage type should be filtered to 100

If warehouse is null, then no filtering on storage type and should get records for all storage types.

How can I achieve this. Any ideas pls.

[Anonymous · Accepted solution]

I created a flag with the logic I need. then added that flag to the report level filters. It worked. 

[Eric_Zhang]

---

@Anonymous wrote:

Hello 

I have columns like WareHouse, Plant, Storage Type, Storage Bin in one table and i built report on top of this table with a slicer on warehouse.

.

The filtering requirement is as below -

If warehouse selected is not null, then Storage type should be filtered to 100

If warehouse is null, then no filtering on storage type and should get records for all storage types.

How can I achieve this. Any ideas pls.

---

@Anonymous

Could you post any sample data? It sounds that you can achieve the goal with some tricky measure composed with ISFILTED, ALLEXCEPT etc.