Dax-formula:Show how many people has called more than once in the last 14 days

[Caze982]

Hi everyone

I have two columns one where i have phone numbers and one where i have dates. I would like to write a DAX-formula thats shows how many people in the last 14 days have called more than once. Does anyone know how to do that?

Sincerly
Christian

 

[mart37]

Add a calculated column:
Count of Calls =
VAR __CurrentRowID = Table1[Phone number]
RETURN
COUNTROWS(
FILTER(
ALL(Table1);
__CurrentRowID = Table1[Phone number]
)
)

Add a measure:
Calls=
CALCULATE(
DISTINCTCOUNT(
Table1[Phone number]
);
FILTER(
Table1;
Table1[Date]>=TODAY()-14 && Table1[Count of Calls]>1
)
)

 

[Caze982]

Add a calculated column:
Count of Calls =
VAR __CurrentRowID = Table1[Phone number]
RETURN
COUNTROWS(
FILTER(
ALL(Table1);
__CurrentRowID = Table1[Phone number]
)
)

Add a measure:
Calls=
CALCULATE(
DISTINCTCOUNT(
Table1[Phone number]
);
FILTER(
Table1;
Table1[Date]>=TODAY()-14 && Table1[Count of Calls]>1
)
)

Thank you very much for your answer. Have a nice day