it's been awhile since I've reached out to your collective wisdom. Hopefully I format everything correctly.

I've got the following DAX formula for my second slicer, but the filter is not applying to both slicers. I found an answer on another question on here, but cannot seem to figure out how to rewrite this properly. I am new to Power BI, so please bear with me.

I am simply running a comparison of sales over time and followed the tutorial I found, but her data set is considerably simpler than the one I am using. The top slicer seems to be working perfectly, but this bottom slicer should only be pulling data from the sales table when the status = sold. This is a page filter I have set. The other question I found on here had the same problem and all that needed to be done is for the page filtering for this specific slicer to be included, but since the reference column is on another table, I cannot seem to work it out. Thanks so much in advance!

TL:DR - Include a filter from another database table on the following DAX to be used on a slicer to compare two different years' worth of sales.

BottomSlicerData = CALCULATE(Count(SaleItem[SaleID]),ALL(Sale[SaleCompleteDate]),USERELATIONSHIP('Sale Copy'[SaleId],SaleItem[SaleID]))

ETA: Here's a screenshot of the report and what it should look like. Filter 1 and Filter 2 must be set to the same value or else the whole thing doesn't work. Also notice that even though they are set to the same value, the bars are different heights. That's the filter of status 'sold' not being applied to Filter two. Also, on the right hand side of the screen, you can see that this report references six different tables. I tried to append/merge my request, but was getting some weird results, so I figured I'd tackle one giant at a time.

Here's a screenshot of the relationships that are active (hopefully this helps)