Count occurrences of user

[rco123456]

hi i want to create two mesures, 

one that calculate new user and one that calculate  return user

date	userid	activityid
1/1/2020	1	1
1/1/2020	2	2
1/1/2020	1	3
2/1/200	1	4
2/1/2020	1	5
3/1/2020	1	6

user number 1 will be return user , becuse he will apper in the recoreds in a few diffrent date.

user 2 will be a new user, becuse he apper only on the first day of the records 

[Jihwan_Kim · Accepted solution]

New User Measure : =

VAR _firstdayoftherecords =

CALCULATE ( MIN ( Data[date] ), REMOVEFILTERS ( Data ) )

VAR _newtable =

ADDCOLUMNS (

SUMMARIZE ( Data, Users[userid] ),

"@firstdaycount", CALCULATE ( COUNTROWS ( Data ), Dates[date] = _firstdayoftherecords ),

"@otherthanfirstdaycount", CALCULATE ( COUNTROWS ( Data ), Dates[date] <> _firstdayoftherecords )

)

VAR _filtertableforcount =

FILTER ( _newtable, [@firstdaycount] > 0 && [@otherthanfirstdaycount] = 0 )

RETURN

COUNTROWS ( _filtertableforcount )

Return User Measure : =

VAR _firstdayoftherecords =

CALCULATE ( MIN ( Data[date] ), REMOVEFILTERS ( Data ) )

VAR _newtable =

ADDCOLUMNS (

SUMMARIZE ( Data, Users[userid] ),

"@firstdaycount", CALCULATE ( COUNTROWS ( Data ), Dates[date] = _firstdayoftherecords ),

"@otherthanfirstdaycount", CALCULATE ( COUNTROWS ( Data ), Dates[date] <> _firstdayoftherecords )

)

VAR _filtertableforcount =

FILTER ( _newtable, [@firstdaycount] > 0 && [@otherthanfirstdaycount] > 0 )

RETURN

COUNTROWS ( _filtertableforcount )

https://www.dropbox.com/s/ml9isvplv84zk8x/74.pbix?dl=0