Determining Lost Subscribers DAX Table

[mattyj2009]

I found an article that has helped me tremendously that has how to determine lost subscribers based on the customer name (I'm using AccountID in my situation).  At the very end of the article it states how to view the results with a dax query.  So what I have done is replicate this same dax query as a new table under the modeling tab in desktop and it gives me exactly what I was wanting.  My only problem is I need a way for users of my report to be able to select different months.  I have a date table with all the possible dates but at the end of the dax query it is hard coded for a specific month.  I'm not having any luck using this like MAX or SelectedValue but it could just be because I am doing it incorrectly. 

The article I'm referring to is https://javierguillen.wordpress.com/2012/08/24/determining-customer-retention-in-dax/

Below is the formula I'm using to pull the lost users data in a table.

[v-angzheng-msft]

Hi, @mattyj2009 

May I ask if your problem has been solved? Is the above post helpful to you?

If  it does, could you please mark the post which help as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.😀

And it would be better if you could post the solution here which will benefit other users who might have the same issue.

[v-angzheng-msft]

Hi, @mattyj2009 

You will be able to use the SUMMARIZE function to summarize all the months into a new table and then use the SELECTEDVALUE function. And to create a slicer to filter on the months, so you can select the month you want.

Note that the slicer is set to single selection.

Or, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

Best Regards,
Community Support Team _ Zeon Zheng

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

[amitchandak]

@mattyj2009 , Refer if my blogs can help

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...

Customer Retention Part 2: Period over Period Retention:https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...