Forum Discussion
How to get counts of temp table variable ?
I'll figure out the remaining on it. I appreicate the push in the right direction, it's defenitely closer and almost there. Thanks again.
Super UserAnonymous because you are just doing a simple count, you didn't put the check for duplicates, so it makes sense why you are getting such a big number.
You are basically counting all the rows and my original measure is different.
To clarify, when I use the whole code you had sent over, it says there's lots of duplicates.
So, I used just the highlighted part of the code you sent in a table to see what it was doing, and like you're mentioning, this inner part of the function is counting all the rows instead of counting the dupilcates.
So, by the time it passes this data to the outter SUMX function, it makes sense that there are lots of duplicates, as it appears to be counting all the rows in the table. Does that make sense?