Forum Discussion

ssaadat's avatar
ssaadat
Regular Visitor
4 years ago

Repeat Customers - for each Item.

Hi,   Good day to all,   I have been trying to create a measure to calculate number of repeated customers. To use in a matrix to filter for number repeated for each Item ID. I have used methods m...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

ssaadat , in this blog, refer repeat and use customer and item inside summarize

 

example

Retained Customer This Month = sumx(summarize(Sales, Customer[Customer], Item[Item]), if(not(ISBLANK([MTD])) && not(ISBLANK([LMTD])) , 1,BLANK()))

 

 

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458