Make Measure Value Fixed Regardless of Dimension in the Visual

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]:

f7c5d47c-e614-4828-8001-4f2e925a4ee4.jpg

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?

0fb5e998-7412-4c6c-b32a-4619b9369771.jpg
dfb60b6d-89ba-4089-a648-6b77a4336409.jpg

I’ve looked for many methods in LookML, but to no avail. Thanks much in advance.

0 2 2,178
2 REPLIES 2
Top Labels in this Space
Top Solution Authors