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...
You may use ISINSCOPE to add a measure.
@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.