I am using the following statement in set analysis
=Sum({<Status = {'Order'}>}[Order value])
However, I want this expression to ignore any other selection from filter from the status field. For example if any status other than Order is selected, this expression should still show the data for Order status
your formula will consider only Order Value with status 'Order'. So it doesn't matter if you select other Status, it will be ignored. If you want to ignore other selections apart from Status, you have to put something like this:
