Forum Discussion
Storing multiple value's in a variable?
Hi Joshmarsteffens,
Have you resolved your issue? If you have, please mark corresponding reply as answer, and welcome to share your own solution.
If you have other problem, please feel free to ask.
Best Regards,
Angelia
Hello v-huizhn-msft,
Sadly this has not fixed my issue
The problem I have is, that I have a distinct id in the target table however the data I get comes from a table that doesnt have distinct numbers on that same column. (so the columns used in the condition for the LOOKUPVALUE())
The result of this is that when you have ID 1 it may or may not return 6, 92, 199 ,32 but what i would want it to return is 4, the count of the results.
However I can't use ANY of the counts as it will just result in an error saying that it needs a column or an table or rows to be able to count. I can not use any of the counts over an varriable.
A collega of mine came with an sollution. In my case the SUMMARIZE() function can be used here to get the results I wanted to see.