I would really appreciate some help with a problem I have very frustratingly failed to solve
I have a file that contains a number of customers per period. Some buy just once, some buy multiple times.
I want to know how many customers remain in the subsequent period
Period 1 = 24 customers
Period 2 = 3 of 24 customers
i want to figure out how to get 3 in period 2
Solved! Go to Solution.
Then update the measure as below.
Measure = CALCULATE(DISTINCTCOUNT(vw_busdev_report_revised[Name]),FILTER(vw_busdev_report_revised,[Measure 2]=1))
You are a new member and i can say that this post doesnt help at all to understand your issue.
Could you please provide us with some more information, visuals or even a sample dataset so as to understand your problem better?
|Period No||Recruits||New Distributors||%||# Distributors from previous Period|
ex. out of 188 new distributors in period 1
i want to know how many distributors sell again in period 2
To create a measure as below. If it doesn't meet your requirement, kindly share your excepted result to me.
Distributors from previous Period = var No = MAX(Table1[Period No]) var per = CALCULATE(SUM(Table1[Recruits]),FILTER(ALL(Table1),Table1[Period No]=No-1)) return IF(ISBLANK(per),BLANK(),per-CALCULATE(SUM(Table1[New Distributors])))
For more details, please check the pbix as attached.
I think i have to define each column
Recruits - are not yet distributors until they sell and converted to new distributors
New Distributors - i was able to get the new distributors coming from our recruits
I want to know how many new distributors will perform again on the next period
out of 399 recruits, we were able to convert 188 new distributors in period 1
now, im interested to know out of 188 new distributors how many distributors will perform again on Period 2
i think i have to define each column
recuits - are not yet distributors
new distributors - are distributors coming from recruits who do their first sale
i want to how many new distributors will perform again on the next period
out of 399 recruits in Period 1 we were able to convert 188 new distributors
now, im interested to know out of 188 new distributors in Period 1 how many will stay/sell again on Period 2
To create the measures as below.
Measure 2 = var no = MAX('Sheet1 (2)'[Periodno]) var t =CALCULATETABLE(VALUES('Sheet1 (2)'[Name]),FILTER(ALL('Sheet1 (2)'),'Sheet1 (2)'[Periodno]<> no )) return IF(SELECTEDVALUE('Sheet1 (2)'[New Customer])=FALSE(),BLANK(),IF(SELECTEDVALUE('Sheet1 (2)'[Name])in t,1,0))
Measure 3 = SUMX('Sheet1 (2)',[Measure 2])
As the data you shared, the result should be like this.