Forum Discussion
DAX_merchant
Helper II
Helper IIAdding a column in a matrix or table
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...
not so much ISFILTERED but HASONEVALUE
lbendlin
Super User
Super Userno, but you can repurpose the column total area as I described.
DAX_merchantHelper II
Helper III 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
not so much ISFILTERED but HASONEVALUE
- DAX_merchant
Great, this is very cool, thank you.