Need a Subtotal that filters current YTD and Prior YTD

[bueroj]

I am trying to measure the percent change from now compared to the prior year. Prior year is calculated using the SAMEPERIODLASTYEAR function which seems to prevent most solutions I'm finding online.

I want my subtotals in my matrix to ignore rows that aren't populated for both the current year and the prior year.

Here is sample data:

Here are the results I get vs what I want:

I feel like I must be missing some simple solution, something with SWITCH, FILTER, or SUMX or some combination of these... 

Please help!

[v-chuncz-msft]

@bueroj,

You may use ISINSCOPE to add a measure.

https://community.powerbi.com/t5/Desktop/Matrix-How-to-avoid-Total-and-Subtotal-aggregation-for-a-fi...

[bueroj]

@v-chuncz-msft thanks for the reply. However I don't see how ISINSCOPE will help. It looks like that just removed subtotals for everything. I want to exclude select records from the subtotal (records that don't have data in BOTH year 1 and year 2). Am I missing how to use ISINSCOPE to identify records not in both years? I do want to have the subtotal displayed, I just want it to exclude particular records depending on if the record was there last year and this year.