cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
waterphil Frequent Visitor
Frequent Visitor

Re: Customer Retention from previous period

Hi Frank,

 

my computer got hung when I tried to use measure 3 in my actual datasets, measure 2 is working fine

waterphil Frequent Visitor
Frequent Visitor

Re: Customer Retention from previous period

Hi @v-frfei-msft

 

computer got hung if I'm using my actual dataset 
tried to remove some rows to test, measure 2 is correct but measure 3 gives me an incorrect value

 

heres my test file

 

Thanks!

Community Support Team
Community Support Team

Re: Customer Retention from previous period

Hi @waterphil,

 

Then update the measure as below.

 

Measure = CALCULATE(DISTINCTCOUNT(vw_busdev_report_revised[Name]),FILTER(vw_busdev_report_revised,[Measure 2]=1))
2.PNG
 
Regards,
Frank
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Customer Retention from previous period

Hi @waterphil,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.


Regards,
Frank

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