Forum Discussion

nulldemon's avatar
nulldemon
Frequent Visitor
6 years ago
Solved

Need Help Calculating repeat customers Percent monthly from Customer and sales

Team Leads have agents below them. Each agent books loads. We want to know which agent has repeat carrier business. As you can see When clicking on Dax in the month of April, he used carrier Bline 3 ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Change the repeat formula to

    Repeat = 
var l1 =SUMMARIZE(Sheet1,Sheet1[Carrier],"G1",SUM(Sheet1[Loads]))
var _rep= CALCULATE(sumx(filter(l1,[G1]>1),[G1]))
return _rep

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks.

nulldemon's avatar
nulldemon
Frequent Visitor
6 years ago

I added it to our main dataset. Here is what we are getting. 

 

So we look at brandon he had 86 loads. so the math should be 7/86 should be 0.08138 or 8.1%

 

it is showing 0.03.

 

So we are filtering out what agent has booked more than 3 loads with one carrier.  

 

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Change the repeat formula to

Repeat = 
var l1 =SUMMARIZE(Sheet1,Sheet1[Carrier],"G1",SUM(Sheet1[Loads]))
var _rep= CALCULATE(sumx(filter(l1,[G1]>1),[G1]))
return _rep

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.