Forum Discussion
Report Level Filtering based on a condition based of two columns
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.
2 Replies
Eric_ZhangMicrosoft Employee
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.