Budgets vs Fact

[Analitika]

Is it possible to do Matrix like this, with two lvl headers, 1st lvl must be dinamic depending on selected year and month

M1 = CALCULATE(SUMX(Table1, Value), Table1[Year] = Selected Year)

M2 = CALCULATE(SUMX(Table1, Value), Table1[Year] = Selected Year,  Table1[Month] = Selected Last Month)

M3 = CALCULATE(SUMX(Table2, Value), Table2[Year] = Selected Year,  Table2[Month] = Selected Last Month)

M4 = DIVIDE(M2-M3,M3)

M5 = M1 - M3

Expected result matrix

[Anonymous · Accepted solution]

HI @Analitika,

It is impossible to default matrix to customize headers as you wanted, measure expressions can be dynamically change based on the current selections.

I'd like to suggest you create a matrix with the group and all measure expressions, then you can create some measures to show the selected ranges and use them on card visual to and combine with the matrix as custom headers.

Xiaoxin Sheng