summarize table by first occurance based on filter

[skutovicsakos]

I want to tell 2 things of each id:

• first read date (blank if there wasn't any)
• No. of reads

Sample table for demonstration:

id	date	action
1	09/04/2019 12.55.24	create
2	09/04/2019 12.55.28	create
2	09/04/2019 12.55.32	read
2	09/04/2019 12.55.40	read

[az38 · Accepted solution]

Hi @skutovicsakos 

First read = CALCULATE(MIN(Table[date]), ALLEXCEPT(Table, Table[Id]), Table[Action]="read")

and

First read = CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[Id]), Table[Action]="read")