Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Matrix : Drill down column differences for each Category

Hi Team, I have a Matrix table with column drill down, Please advise on the differences for the each category. please share the dax functions for the differences.
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

If Region more than 2, then how do I change dynamicly.

Please advise.

 

Thanks,

w_Das