I'm not sure if this will work for your true setup, but maybe this can give ideas:
There may be easier ways, but I tried this multi-step method
-create a dimension which is the first three characters: LEFT([Flightnumber],3)
-create a set from that group picking only the three-letter codes you want
-put the set on the filter shelf
-put your calculated field (the version without the ELSE "Other") onto the filter shelf
this should remove the "Null" or "Other" choice from the list
Please see workbook v10.3 attached in the Forum Thread:
286949set.twbx 1.2 MB
Hi Penn Wang
The simple way of doing this is
1. Just create a set on your calculated field and select the 'Categories' that you want to show in the drop down.
2. Now place this newly created set in the filter card to show only members in the set.
Have you tried dropping this calculated field onto a parameter and then using that as a filter ? - you can then just omit the 'other' option completely from the list.
This is absolutely madness! Never though about this!
New skill get! Thanks so much!