Calculate delta on matrix visual

Hi Anonymous 

May be you like this way also..Create a index column by dax 

index = RANKX('Table',[Year (groups)],,ASC)

then calculate the previous value measure by considering this index column

You can use a measure like this to do that.  In the total row, there are multiple year group values, so an IF can be used to return a different calculation there.  This measure will return the difference between the max and min values for the year groups.

Sales Conversion New =
VAR vSummary =
    ADDCOLUMNS (
        DISTINCT ( YearGroupDifference[Year (groups) 2] ),
        "cSum", [SalesConversion]
    )
VAR vMax =
    MAXX (
        vSummary,
        [cSum]
    )
VAR vMin =
    MINX (
        vSummary,
        [cSum]
    )
RETURN
    IF (
        COUNTROWS ( YearGroupDifference ) = 1,
        vMax,
        vMax - vMin
    )

You can also rename Total to Difference.

Regards,

Pat

Hi Anonymous,

In fact, the table/matrix visual normally displays the default aggregate mode 'sum' on the total level without any other specific filters.

mahoneypat 's solution is to modify the total level of table/matrix title to 'difference' and writes the measure formula to check the total row content level and show the corresponding value.

Clever Hierarchy Handling in DAX 

For this scenario, you need to manually modify the total level name to change the 'total' to 'difference'. (in format tab -> 'total'/'subtotal' options)

Regards,

Xiaoxin Sheng