Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
I created a flag with the logic I need. then added that flag to the report level filters. It worked.
I created a flag with the logic I need. then added that flag to the report level filters. It worked.
@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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |