Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a custom table. I've made the dimension
=ValueList('TEST1','TEST2')
The measures for this are all very similar, but distinctly different. In the final version there will be FORTY different values in the list, so I'm trying not to make 40 different formulas. (I've already made it, it runs very slowly)
Ideally I'd make a measure like this
Sum({<
[Landing Page Path]={"=$(=pick(match(ValueList('TEST1','TEST2'),'TEST1','TEST2'),{"*/Test1*"},{"*/Test2*"}))"},
Date=
>}Sessions)
I can get it to work like this
pick(match(ValueList('TEST1','TEST2'),'TEST1','TEST2'),
Sum({<
[Landing Page Path]={"*/Test1*"}
Date=
>}Sessions)
,
Sum({<
[Landing Page Path]={"*/Test2*"}
Date=
>}Sessions))
but like I said as I start to grow to over 40 different values in the table, it REALLLLLLY slows down. I'm trying to simplify this formula
Thanks!
This didn't cut the load time down.
My biggest issues have been solved though, so again, thank you very much.
Adding Sub as dimension resolved your issue?