Forum Discussion
android1
Post Patron
Post PatronCount Distinct but only SUM different numbers
Hi,
I want to sum the number of distinct times a number in Visit Num column occurs. In pic below for e.g 250884 occurs twice. I only want to count this once & display a total sum. Using distinct count which is what the second column is sums everything.
Are you using Table visual? If so, change it to Matrix visual.
Put [Visit Num] into Row field. Add measure DISTINCTCOUNT([Visit Num]) as value field.
6 Replies
Can you try create this measure:
Count:= CALCULATE(COUNTROWS(Table))
Then place them intable with the Visit Number:
Let me know if this helps. Thanks.
- Chihiro
Solution Sage
Are you using Table visual? If so, change it to Matrix visual.
Put [Visit Num] into Row field. Add measure DISTINCTCOUNT([Visit Num]) as value field.
