count the new users and one that count returen users

[rco123456]

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

[rco123456]

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

[amitchandak]

@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])