Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Keep returning text in my visualization rows

Hi,   I keep pulling up text in my matrix for this dax measure Average Spend = VAR CohortStartMonth = SELECTEDVALUE('AR Invoice'[Cohort]) VAR CurrentMonth = EOMONTH(CohortStartMonth, SELECTEDVALU...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Anonymous , if you are looking for Cohort analysis refer

 

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410

Power BI Cohort Analysis, Customer Retention %- https://youtu.be/qY1SDF1cwsg

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Amitchandak,

I implemented your retention solution instead and it works great but I have a question. My results are showing 100% everywhere and I'm not sure where I went wrong. I am pulling from my ar invoice table the customer id's 

 

Preview
Retain % = CALCULATE(divide(DISTINCTCOUNT('AR Invoice'[customer_id]),CALCULATE(DISTINCTCOUNT('AR Invoice'[customer_id]),ALLSELECTED('Customer Age Bucket') , 'Customer Age Bucket'[Age] =1)) , 'Customer Age Bucket'[Age] >1)  Where do you think I went wrong?