Assistance needed

[SuzanneSte]

Hello, I hope you can guide me on this problem.

I am attempting to count each instance an appoinmtent is created (Event Created date), but I need to exclude lines from the count if another element (invitees email address), is duplicated in the dataset. 

So firstly, I am trying to identify duplicates in the email addresses and store them in a created column

Having difficulty with that

Can you advise please 

[SuzanneSte]

Thank you !!!

Great help

[some_bih · Accepted solution]

Hi @SuzanneSte  your RepEmailCol calculated column could be like below. Hope this help

RepEmailCol=
--Check_duplicate
VAR _currentvalue='events-export'[Invitee Email]
VAR _count_filtering=
COUNTROWS(
FILTER(
'events-export',
'events-export'[Invitee Email]=_currentvalue
)
)
VAR _Result=
IF(
_count_filtering>1,
"Duplicate",
"Distinct"
)
RETURN _Result