Performance Set vs Flag

[#1]

We are discussion how to best solve calculations comparing (Shoes_Flag in Fact table)

Sum(Shoes_Flag * Sales)

Sum({<Shoes_Flag={1}>} Sales)

when you have 30 M rows and 100 users regarding memory and response time?

Will Section Access affect memory and response time?

[Clever_Anjos]

Sum({<Shoes_Flag={1}>} Sales) should perform better because the selection is made before the calculation.

For example, if 30% of records are Shoes_Flag=1, only 30% are accumulated

[swuehl]

There are multiple questions in your post, these posts are about flag vs. set analysis performance:

Optimize UI Performance with Flags and Set Analysis

Performance of Conditional Aggregations

[Clever_Anjos]

Further reading: Performance of Conditional Aggregations