Need to make these graphs filterable by both slicers *SAMPLE PBIX ATTACHED*

[kjohnanand]

Hello everyone. I'm working on a project where I need to show trennding revenue for active clients by quarter. For example, if Q1 2022 had 2000 active clients and I selected that quarter in my slicer, I want a revenue trending graph that shows revenue for those 2000 clients between 2020-2024, regardless of whether they deconverted later.

I'm attempting to do this using a disconnected date table, and I can get it to work, but when it does, another slicer in my report breaks and no longer functions.

I've attached a sample PBIX that contains relevant data. In that pbix, both slicers should work to filter the graph, but I can only get one to work at a time. Any help on this would be much appreciated.

https://upload.disroot.org/r/JBjAgytN#dDNJTdfJ+BUTtcwGn46l0iSRVXZTk+jMfdFwoKCm67s=

[lbendlin]

Your sample file is too big and too complex. Do not include sensitive information or anything not related to the issue or question.

[kjohnanand]

Something interesting I noticed - looks like selecting certain specific quarters (such as Q2 2020 and Q1 2021) filter down the table properly, but this doesn't apply to all the quarter selections. Any thoughts on why this would happen?

https://upload.disroot.org/r/jswn3G8Q#Q5s3vKWswoYJb39SZEnOcWgJTiSQxSmehrulLtspQ3k=

[kjohnanand]

Hi, sorry about the file size. I removed a lot of the tables and simplified a bit to make it easier. What I need to do is make both slicers in the file filter the trending graph. The issue is with my core cohorts measure, I believe. 

https://upload.disroot.org/r/udRJJr33#oxSJasRdnrZyYmawlqIsGZb8Y9z+rzmP1t0HYSFr1fM=