Maybe I am missing something obvious, but when creating a calculated field that tests if certain conditions are met by a specific value in a dimension, is there a way to see, or populate, the values within the calculated field editor? Otherwise, we have to remember the values and hope for no typos.
if [Category] = 'Office Supplies' THEN ....
If I didn't remember Office Supplies or mis typed, condition will never be met.
The way I normally deal with this is to open a new tab on a workbook and drop the pill of interest on rows. And because the new versions allow for a popup calculator field, this works pretty well to see the values and type in the calculator editor!