Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • tex628's avatar
    tex628
    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.

    :->

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for your reply, but the calculated column doesn't seem to work.

Edit: I've corrected ":" to ";", but there still seems to be a problem with the definition of variables.

tex628's avatar
tex628
Community Champion
7 years ago

Right, it doesnt let you name things to those specific names :p Just rename them and change the ":" at the end!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.

    • tex628's avatar
      tex628
      Community Champion
      7 years ago

      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!

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Yea sure, it's either 0 or 1, there are no other numbers