Skip to Content
1
Jul 06, 2022 at 02:03 PM

Lookup function is not working

159 Views

Hello all, I'm trying to create a kpi that ignores all page/story filters, until now I was using a calculated account with all dimensions under "enable constant selection" but, to avoid repeating the same calculated account again and again, I tried creating a LOOKUP formula in the model:

image.png

The issue is it doesn't work, if I filter something in the screen, both the LOOKUP and the regular accounts will be filtered:

image.png

Any idea on what is the issue there? Thank you in advance.

Attachments

image.png (28.8 kB)
image.png (19.3 kB)