Forum Discussion

MatH's avatar
MatH
Frequent Visitor
4 years ago
Solved

Counting repeat callers

I want to be able to have a card that reports on repeat callers.   The table basically looks like this:   The CLI column is the users phone number, I wanted to be able to count how many tim...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi MatH 
    Please try

    More Than 5 Calls =
VAR T1 =
    SUMMARIZE (
        TableName,
        TableName[CLI],
        TableName[Date],
        "@NumberOfCalls", COUNTROWS ( TableName )
    )
VAR T2 =
    FILTER ( T1, [@NumberOfCalls] > 5 )
VAR T3 =
    SELECTCOLUMNS ( T2, "@CLI", TableName[CLI] )
VAR Result =
    COUNTROWS ( DISTINCT ( T3 ) )
RETURN
    Result & "people called more than 5 times in a day"
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I tried to create a sample pbix file like below.

I hope the below can provide some ideas on how to create a solution for your data model.

Please check the below picture and the attached pbix file.

 

 

expected measure: =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ( Data[CLI] ),
            "@callcountperday", CALCULATE ( COUNTROWS ( Data ) )
        ),
        [@callcountperday] > 4
    )
)