Adding a column in a matrix or table

[DAX_merchant]

Hello, 

I have a matrix with each row containing a store, and columns by fiscal year - quarter. The values of the matrix are sales. I want the last column in the matrix to be the delta betwen the latest fiscal quarter and last years performance of the same quarter. How do I add a column to the matrix without the delta value showing up for every quarter?

Not sure if that makes sense. But basically I want column 1 = Fy 2023 Q1, column 2 = FY 2023 Q2, etc... Last column = Delta. 

[DAX_merchant]

Right now I have it so that if the context is not in the latest quarter, then it returns blank, then I turn text wrap off and close all the delta columns. Just was wondering if I could put a measure in the columns field if that makes sense, so show a column that is not part of the date. 

[lbendlin]

no, but you can repurpose the column total area as I described.

[DAX_merchant]

I did not realize this is what you meant. Can you elaborate? I can't seem to find where to place a field that would show a custom calculation in the total column for a matrix. Alternatively, do you mean using isfiltered in the measure placed in values, then return only my delta when isfiltered(quarter) evaluates to false?

Furthermore, can you elaborate on what you mean when you say a measure is calculated four times in a matrix visual?

[lbendlin · Accepted solution]

not so much ISFILTERED but HASONEVALUE

[DAX_merchant]

Great, this is very cool, thank you. 

[lbendlin]

Remember that in a matrix visual a measure is calculated four times. You can have a different calculation for the column totals area (and accomodate your delta there).