Budgets vs Fact

Analitika — Thu, 07 Jan 2021 19:04:23 GMT

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

Re: Budgets vs Fact

Anonymous — Mon, 11 Jan 2021 01:50:26 GMT

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

topic Budgets vs Fact in Developer

Budgets vs Fact

Re: Budgets vs Fact