Forum Discussion
returning customer count
Hey folks, I know that this topic was already discussed, but I didn't get any of the solutions to work that were posted here before. I was able to solve my problem with 2 dax tables + measure, bu...
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.
:->
tex628
Community Champion
Community ChampionIn that case, make a new column with [did] and [groups]:
did_groups = [did] & [Groups]
Then replace [did] with the new column in the measure below.
This should reduce the amount of returning customers that ur getting.
Column =
VAR ID = [did_group]
VAR DATE = [ltime]
return
IF(CALCULATE( SUM([lon]);
ALL("YOURTABLE");
[did_group] = ID;
[ltime] < DATE
)
>0
;1:0)It doesn't work...Still way too many returners. I also don't think that is that easy.