Subtract two columns to get progression

[Syndicate_Admin]

Good morning

I have a matrix that looks like this. Each value Loaded, Contacted, % Contact... are measures that are in the Values field in the matrix. I need to get a new column with the difference of the Current - Close column, i.e. Current Loaded - Closed Loaded etc.

To try to get something like that

Is there any way to get what I need?

Thank you all very much

[Syndicate_Admin]

I was on vacation and hadn't seen the answer.

Thank you you have solved the problem I had

[v-yanjiang-msft · Accepted solution]

Hi @Syndicate_Admin ,

According to your description, here's my solution.

1.Create a new table with a single column, create relationship with the fact table.

2.Create new measures or directly modify the original measures.

Contactados2 =
IF (
    MAX ( 'New'[New Column] ) = "Prog",
    CALCULATE (
        [Contactados],
        FILTER ( ALL ( 'Table' ), 'Table'[Column] = "Actual" )
    )
        - CALCULATE (
            [Contactados],
            FILTER ( ALL ( 'Table' ), 'Table'[Column] = "Cierre" )
        ),
    [Contactados]
)

Aceptotas2 =
IF (
    MAX ( 'New'[New Column] ) = "Prog",
    CALCULATE (
        [Aceptotas],
        FILTER ( ALL ( 'Table' ), 'Table'[Column] = "Actual" )
    )
        - CALCULATE (
            [Aceptotas],
            FILTER ( ALL ( 'Table' ), 'Table'[Column] = "Cierre" )
        ),
    [Contactados]
)

Get the correct result:

I attach my sample below for your reference.

Best regards,

Community Support Team_yanjiang

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