YoY % Change Matrix Total Calc

Question

Hello I created a YoY measure that outputs blank values if the YoY divison formula outputs a -1 or 0. This works fine for graphs, but when I use this measure in a matrix, the total is very off. This is because I do not have complete data for both years, -- there are some months without data.&nbsp;&nbsp;So, how do I get the total displayed in the matrix to only do the YoY calc for months for which I have both 2018 and 2019 data, and ignore months that don't overlap.&nbsp;Here is the measure I am using:&nbsp;SelectedMetric YoY% = VAR __PREV_YEAR = CALCULATE([SelectedMetric], DATEADD('dimdate2'[Date].[Date], -1, YEAR))&nbsp;&nbsp;&nbsp;&nbsp;RETURN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(or(DIVIDE([SelectedMetric] - __PREV_YEAR, __PREV_YEAR) = -1,DIVIDE([SelectedMetric] - __PREV_YEAR, __PREV_YEAR) = 0),BLANK(),DIVIDE([SelectedMetric] - __PREV_YEAR, __PREV_YEAR))&nbsp;and here is a screenshot of the output in a matrix, with location names removed. I have also removed the second totals column in the matrix menu.for example: I would like the last line total to show "171.44%" instead of 54.55%

v-eachen-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
You could use IF() and&nbsp;ISINSCOPE()&nbsp;funcitions&nbsp;to change the last value.
Here is my test file for your reference.
&nbsp;

Forum Discussion

Related content

Totals in Matrix

Matrix Totals Incorrect

Formatting grand total in matrix

Incorrect Total for Percent Change in Power BI Matrix Visual

Matrix Row Totals