Forum Discussion
returning customer count
- 7 years ago
This is really confusing.
I've made my own example dataset:
The calculated column "Column" is simply:Column = VAR ID_ = [did_groups] VAR DATE_ = [ltime] return IF(CALCULATE( SUM([lon]); ALL(Table1); Table1[did_groups] = ID_; table1[ltime] < DATE_ ) >0 ;1;0)
Which gives me 7.
Then i use the measure:Measure = Calculate(distinctcount([did_groups]);Table1[Column]=1)
Which removes 1 and give's me 6. Which should be the correct number of returning customers in the dataset that I made.
:->
Right, it doesnt let you name things to those specific names :p Just rename them and change the ":" at the end!
Thanks, there are no syntax errors now., but the result is wrong so I guess that it does not work this way.. It counts way too many as returning customer.
- tex6287 years agoCommunity Champion
Is it possible to for you take a picture of the timestamps and the calculated column?
Like this?
Edit: Ignore the 2's in the picture!- Anonymous7 years agoNot applicable
Yea sure, it's either 0 or 1, there are no other numbers
- tex6287 years agoCommunity Champion
Thats really weird.
If you filter on a single returning [did] and then sort by acending dates, how does it look?