Forum Discussion
CA8172
Helper I
Helper INeed a Count on Distinct Information
I am trying to create a Measure or a Column that will count the distinct information either based on an account number or first/last name. I tried COUNTROWS, I tired DISTINCT, and even 'Grouped By',...
CA8172Helper I
Helper ISomeone had asked about the logic, but might have figured it out since it appeared to be deleted. However I will still respond.
And now looking at it, I forgot one column "Products". So when a customer is interested in a product, they request it. Which then creates a Case Number. That is the only unique key that is different for similar customers. So take for example Sam Spring, he has two cases, because he is interested/purchased two different products (ie: Sweater and Phone Charger).
I hope that clarifies the difference, since I forgot to include "Products" in the screen shot.