Forum Discussion

JCovelli's avatar
JCovelli
Icon for Helper I rankHelper I
8 years ago
Solved

“Frequent Caller” metric

Hello Group! Does anyone know how I might use DAX or Power BI to calculate our “Frequent Caller” metric here at work?… we say that anyone of our members who has called us more than one time in a wee...
Need Help
  • dramus's avatar
    dramus
    8 years ago

     

    I created a new summarize table:

     

    Last Called = summarize(Calls,Calls[Caller],"Last Called",max('Calls'[Date]))

    Then I added a new Column:

    Frequent Caller = if(countx(filter(Calls,datediff([Date],'Last Called'[Last Called],DAY)<=7 && [Caller]='Last Called'[Caller]),[Caller])> 1,"Yes","No")

    Here's a pic of the report.

JCovelli's avatar
JCovelli
Icon for Helper I rankHelper I
8 years ago

Hmm, but how could one tell between members who have called more than one time, versus those who have called multiple times withint a 7-day period?

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
8 years ago

 

I created a new summarize table:

 

Last Called = summarize(Calls,Calls[Caller],"Last Called",max('Calls'[Date]))

Then I added a new Column:

Frequent Caller = if(countx(filter(Calls,datediff([Date],'Last Called'[Last Called],DAY)<=7 && [Caller]='Last Called'[Caller]),[Caller])> 1,"Yes","No")

Here's a pic of the report.

  • JCovelli's avatar
    JCovelli
    Icon for Helper I rankHelper I
    8 years ago

    This looks very interesting! I am also a beginner in alot of ways with this stuff, so please forgive the questions.

     

    1. If you added some call instances for your Caller 3, for example a call on 1/12, another on 1/13, and another on 1/29, would the system you designed show Caller 3 as a Frequent Caller "Yes"

     

    2. Would it show the number of calls within a 7-day period to be 3? 1/12, 1/13, and 1/15 and NOT include the call on 1/29?

  • dramus's avatar
    dramus
    Icon for Continued Contributor rankContinued Contributor
    8 years ago

    I added some of the dates as you requested,

     

    If you want a copy of my PBIX, PM me with your email address and I'll send you a copy.

     

    There seems to be a kink in the # of calls in the last seven days, sometimes it get s the rigth answer and sometimes it over compensates by one.

  • JCovelli's avatar
    JCovelli
    Icon for Helper I rankHelper I
    8 years ago

    Thanks Rob for Solving the riddle!

     

    John