Esther Twain wrote:
Has this something to do with the fact that by using FIXED there is no adaptation at whatever new dimension we bring into or out of the view? In other words, is this an advantage or disadvantage of using Fixed LOD?
Yes to your first question. The answer to your second question is: It depends on what you're trying to do. If you want this behavior, then it's an advantage; otherwise it's a disadvantage. In my mind Fixed LODs have a couple of uses:
-- Change the order of execution so the Fixed LOD is not affected by pills on the filter shelf (unless you add 'Context' to them). This makes calcs like % of Total much easier, avoiding the need to use Table Calculations.
-- Aggregate an aggregate
There are lots of other uses, which you can find here: Top 15 LOD Expressions | Tableau Software
Hope this helps.