Calculate % change between two columns relevant to the slicer

[Matt_manderA]

Hi guys, 

I am really struggling with this one. I have a matrix like the one below and I am trying to calculate for every single line Size 1 Stock divided by Size 1 IAQ. However, when I use the DIVIDE function, it gives me very strange %'s. I also need this to be dynamic depending on what is selected on the slicer (Online Channel). 

Any help is very much apprecaited. 

Thanks

[v-lionel-msft · Accepted solution]

Hi @Matt_manderA ,

Or like this?

Measure 2 = 
DIVIDE(
    SUMX( 
        FILTER( table, table[column] = "Size 1 Stock" ),
        table[value]
    ),
    SUMX(
        FILTER(
            table, table[column] = "Size 1 IAQ"
        ),
        table[value]
    )
)

If not please show me the .pbix file or sample data.

Best regards,
Lionel Chen

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