Customer Count Distinct value based on slicer

[Chanleakna123]

HI ALL , 

our purpose is to find out how many customer purchased 1 time =Customer PUrchase and customer purchased more than 2 times Customer Repurchased ( based on the period selected ,We don't care which brand or flavor , but if they purchased we count all the Numer of Customer in Distinct Count. 

i have table below :

PS : Value = Purchased

i wanna find out : 
****Customer Purchased : based on the Date selected , If they have purchased >1 time = Customer Purchased ( We don't care which brand or flavor they purchased ) if they have value >0 we count them purchased ,and  Customer Purchased need to Count by distinct Customer 

Based on ex below : we have 3 customer Purchased  are 2THNOO,23 coffee,dalin grill  beacause all have value 

****Customer RePurchased : based on the Date selected , if they have purchased >2 Times of Date ( for ex : purchased on 15 Mar & 11 Jan & so on... ) = Customer Repurchased (We don't care which brand or flavor they purchased ) and Customer Repurchased need to Count by distinct 

Based on ex below : we have 1 customer RePurchased is 23 Coffee  

Everything will be calculated based on the slicer , of Date , Brand , Flavor and so on , 

Please note that All customer Count only Distinct 

[v-jayw-msft]

Hi @Chanleakna123 ,

Please refer to the Measures below.

Measure = IF(SELECTEDVALUE('Table'[Date])>=MIN('CALENDAR'[Date])&&SELECTEDVALUE('Table'[Date])<=MAX('CALENDAR'[Date])&&SELECTEDVALUE('Table'[Value])>0,1,0)

Customer Purchased = CALCULATE(DISTINCTCOUNT('Table'[Customer]),FILTER('Table',[Measure]>0))

Measure 2 = SUMX(ALLEXCEPT('Table','Table'[Customer]),[Measure])

Customer RePurchased = CALCULATE(DISTINCTCOUNT('Table'[Customer]),FILTER('Table',[Measure 2]>1))

Result would be shown as below.

Pbix as attached.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Chanleakna123]

hi @v-jayw-msft  , 

i have done over this , Purchased is correct.

But Re-Purchased is not , because below Customer i highlight bought the different products at the same date on 18 Jan , which is sum to 5.58 , While these numers are sum up 2 times together , in term of Re-Purchased , We Don't count this customer into Re-Purchased. he just bought 2 times at the same date , so we don't count it. 

[v-jayw-msft · Accepted solution]

Hi @Chanleakna123 ,

Please modify Measure2.

Measure 2 = SUMX(ALLEXCEPT('Table','Table'[Customer],'Table'[products]),[Measure])

Result would be shown as below.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.