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:
The issue is it doesn't work, if I filter something in the screen, both the LOOKUP and the regular accounts will be filtered:
Any idea on what is the issue there? Thank you in advance.