Forum Discussion
Need Help Calculating repeat customers Percent monthly from Customer and sales
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.
Super UserI created formulas and added a visual on page 2. But the requirement of getting values above dimension seems to have limitation
https://www.dropbox.com/s/8q0ki3p25ruxmse/test%281%29.pbix?dl=0\
Refer
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.
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
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.