Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I would like to to calculate the total of repeats/returning customers for a certian period.
So my first measure for the below "Distinct email Count", I use = CALCULATE(DISTINCTCOUNT(Table[Column]
Then a simple = IF([Distinct email Count] > 1, "Returning", "Not")
How will I be able to get the total of value for Returning and for Not?
I know there are a couple of articles on New, Lost Customers but just looking for a simplified version of identifying returning customers for a sanity check.
Any ideas?
Kind regards
Solved! Go to Solution.
@amitchandak - thanks for your reply. I might not have been clear with question, however, I managed to get it working with
Hi @Axiomite ,
If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.😊
Best Regards,
Henry
Returning = countx( filter(summarize(Table, Table[Year], Table[Month], Table[email], "_1", CALCULATE(DISTINCTCOUNT(Table[Column] )) ) , [_1] >1) ,[email] )
not = countx( filter(summarize(Table, Table[Year], Table[Month], Table[email], "_1", CALCULATE(DISTINCTCOUNT(Table[Column] )) ) , [_1] <=1 ) ,[email] )
@amitchandak - thanks for your reply. I might not have been clear with question, however, I managed to get it working with
Kudos to you !!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
84 | |
70 |