Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |