Matrix : Drill down column differences for each Category

HI Anonymous,

I'd like to suggest you modify the current columns of matrix to move fiscal year above of the region group. Then these visualization will display the different region values at the same fiscal years group.

formula =
VAR regionA =
    CALCULATE (
        SUM ( Table1[Amount] ),
        FILTER ( ALLSELECTED ( Table1 ), [Region] = "APAC" ),
        VALUES ( Table1[Product] ),
        VALUES ( Table[Fiscal Year] )
    )
VAR regionB =
    CALCULATE (
        SUM ( Table1[Amount] ),
        FILTER ( ALLSELECTED ( Table1 ), [Region] = "EMEA" ),
        VALUES ( Table1[Product] ),
        VALUES ( Table[Fiscal Year] )
    )
RETURN
    regionA - regionB

Regards,

Xiaoxin Sheng