How to show percentage difference between two columns in Matrix

[Anonymous]

I'm new to Pbi. I'm trying to replicate an Excel report to Pbi. Excel pivot table was able to produce the 3 column as the difference by showing values as % Difference between Avg of Client Interaction and Avg of RS Case. I want to achieve the same output on the Total column in Pbi Matrix, is it possible?

  

Thanks in advance.

[tamerj1 · Accepted solution]

Hi @Anonymous 

please place this measure in your matrix instead of the column

Average Case Age (days) =
VAR AverageDays =
    AVERAGE ( TableName[Case Age (days)] )
VAR AverageClient =
    CALCULATE (
        AVERAGE ( TableName[Case Age (days)] ),
        TableName[ColumnName] = "Client Interaction"
    )
VAR AverageRS =
    CALCULATE (
        AVERAGE ( TableName[Case Age (days)] ),
        TableName[ColumnName] = "RS Cars"
    )
RETURN
    IF (
        HASONEVALUE ( TableName[ColumnName] ),
        AverageDays,
        DIVIDE ( AverageRS - AverageClient, AverageClient )
    )