topic count the new users and one that count returen users in DAX Commands and Tips

count the new users and one that count returen users

rco123456 — Thu, 01 Jul 2021 21:01:45 GMT

i'm trying to make a mesure that count the new users and one that count returen users

returen user is is a user that will appear in the records more then one time with a diffrent date

new will be a user with only one apprince in the records

i try this:

ActiveUsers = CALCULATE(distinctcount(FactActivity[UserId]),filter(factactivity,count(date)>1))

example of the data:

date	userid	activityid
1/6/2021	1	11
1/6/2021	1	22
1/6/2021	2	55
2/6/2021	1	66

Re: count the new users and one that count returen users

amitchandak — Fri, 02 Jul 2021 07:55:16 GMT

rco123456 , Try measure

M1 = countrows(FactActivity)

return user = countx(filter(values(FactActivity[UserId]), [M1] >1), [M1])

new user = countx(filter(values(FactActivity[UserId]), [M1] =1), [M1])

Re: count the new users and one that count returen users

rco123456 — Sat, 03 Jul 2021 17:28:34 GMT

it's not working.

it's not take the date in the calculation/ return user will be one that appear in the recorded more then once at a different date