Count only record that duplicates more than X times

[qVeGETzX]

Hello Expert,

My dataset have 3 main table, Areas, Tasks and Customers

Here is some structure

Areas: AreaCode

Tasks: TaskNo, Date, User, CustomerNo

Customers: CustomerNo, CustomerName

I need to display there are how many group of Task that duplicate more than 3 times in each Area (Duplicate is determine by Date+CustomerNo)

and this need to update if we filter for User, Only Task of selected users need to be counted.

Tried my best but still didn't go far about this 😞

Thank you in advance

[Anonymous]

@qVeGETzX  Counting tasks and making an if-else can work.