Calculated Dimension / Show Condition - Performance?
If I have a calculated Dimension who's purpose is to filter a table, and I use an IF statement like the one below, can it have a negative impact on performance? I know in general it's better to use Set Analysis, but I haven't found a way to filter a table dimension using Set Analysis.
Re: Calculated Dimension / Show Condition - Performance?
Thank you for the response Carlos. I knew about this option, but was trying to avoid having an unnecessary aggr field at the end of my table of data. It takes up unnecessary space and seems less than professional. This seems more like a "workaround". Even so, I'm going to mark it your response as the correct answer since it seems like this is the only way to achieve this.