Forum Discussion

mattyj2009's avatar
mattyj2009
Helper II
4 years ago

Determining Lost Subscribers DAX Table

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 stat...
Need Help
v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

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.