Calculated Dimension / Show Condition - Performance?

[#1]

Hello All.

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.

IF([FIELD1]='VALUE',[FIELD1])

[CarlosAMonroy · Accepted solution]

Hi Josh,

In some cases, calculated dimensions may affect your app performance. I think it depends on the data volume and also the complexity of the data model.

You can use the condition in the set analysis.

E.g.

Dimension: FIELD1

Expression: sum(Sales)

Expression using set analysis: sum({<FIELD1={'VALUE'}>}Sales)

That will show only sales for the specific value defined in the set analysis.

Carlos M

[#3]

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.