Ignore filter set analysis

[Antoine]

Hello,

I have a chart that include the following measure:

Sum({<[Cellule]-={""},[oeeGroup]={"OEE100"}+{"OEE101"}+{"OEE900"}+{"OEE901"}+{"OEE153"}>}TOTAL stateTypeTime)

and I want to make sure oeeGroup can't be filtered anymore (Having those 5 values, and not removing any of them from the calculation), but I don't know how to do that... I tried :

Sum({<[Cellule]-={""},[oeeGroup]={"OEE100"}+{"OEE101"}+{"OEE900"}+{"OEE901"}+{"OEE153"},[oeeGroup]=>}TOTAL stateTypeTime)

Which resulted in no longer having the filtering for oeeGroup in the set analysis, so it's not the solution...

I also can't add a {1}, as I still need to use other filters on this chart...

Would greatly appreciate some help !

Antoine

[tresesco · Accepted solution]

May be like this?

Sum({<[Cellule]-={""},[oeeGroup]={"OEE100","OEE101","OEE900","OEE901","OEE153"}>}TOTAL stateTypeTime)

[Antoine]

Thank you ! It works just fine !