Hi @Anonymous ,
I have made a test for your reference.
1. Here is my SharePoint List.
2. Add a Button Control and apply the following formula on its OnSelect property as:
ForAll(
Distinct(datasource,'Assign to'.Email),
Collect(collectionname,
{Assignto: Result,
Num: CountRows(Filter(datasource,'Assign to'.Email = Result,DateDiff('Date closed',Deadline) < 0))}
)
);
Set(variablename,Sum(collectionname,Num))
2. Add a Data Table Control and set its Items property to collection name.
3. Add a Label Control and set its Text property to variable name.
Best Regards,
Charlie Choi
