Forum Discussion
Budgets vs Fact
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
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
1 Reply
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