Hello Looker Community,
I’m wondering if there’s a way to make the value of Measure changes due to the Dimensions in the filter, but not those in the visual.
So for example in Explore, I have the following measures named [Total Utilized Item] and [Total Available Item]:
When we add any dimension field (say [Manager] or [Region]), how can we make sure that the value for [Total Available Item] remains the same (400) across different dimension values, and it should only change due to filter?
I’ve looked for many methods in LookML, but to no avail. Thanks much in advance.