Create a calculated column in matrix visualization

mkim 

Adding a Measure to a Matrix will always show calculation against each Row and Column fields, to hide the values, you can create the following measure, adjust your measure accordingly:

Diff = 
IF(
    ISFILTERED( Table3[YEAR] ) , "" , 
    CALCULATE(
        SUM(Table3[VALUE]),
        Table3[YEAR] = 2016
    ) - 
    CALCULATE(
        SUM(Table3[VALUE]),
        Table3[YEAR] = 2014
    )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Hi mkim ，

Based on your description, you can do some steps as follows.

1. Create an index column.
2. Create two date tables.

Current date = SUMMARIZE('Case3',Case3[index],Case3[DATE])

Prior date = SUMMARIZE('Case3',Case3[index],Case3[DATE])

3. Create a measure.

diff =

var cu1=MIN('Current date'[index])

var cu2=MAX('Current date'[index])

var pr1=MIN('Prior date'[index])

var pr2=MAX('Prior date'[index])

return

CALCULATE(SUM(Case3[VALUE]),'Case3'[index]>=cu1&&'Case3'[index]<=cu2)-CALCULATE(SUM(Case3[VALUE]),'Case3'[index]>=pr1&&'Case3'[index]<=pr2)

  4.Create two clicers.

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.