Hello,

I have this matrix visualization with 2 measures:

AREA	Concepte FACT	Cost	Fact	TempCOST	TempFACT
Area1		1.437,25	2.880,19	1.437,25	2.880,19
	AM	25,00		1.437,25
	EC	20,00		1.437,25
	JS	1.160,00		1.437,25
	MP	35,00		1.437,25
	MR	137,00		1.437,25
	RC	60,00		1.437,25
	LA01		2.778,19		2.880,19
	LA02		102,00		2.880,19
Area2		435,00	0,00	435,00	0,00
	AM	375,00	0,00	435,00	0,00
	JP	60,00	0,00	435,00	0,00

where TempCOST = CALCULATE(SUM(Table1[Cost]);ALL(Table1[Concepte FAC])) and TempFACT = CALCULATE(SUM(Table1[Fact]);ALL(Table1[Concepte FAC])).

I need this result in the table:

AREA	Concepte FACT	Cost	Fact	TempCOST	TempFACT
Area1		1.437,25	2.880,19	1.437,25	2.880,19
	AM	25,00		1.437,25	2.880,19
	EC	20,00		1.437,25	2.880,19
	JS	1.160,00		1.437,25	2.880,19
	MP	35,00		1.437,25	2.880,19
	MR	137,00		1.437,25	2.880,19
	RC	60,00		1.437,25	2.880,19
	LA01		2.778,19	1.437,25	2.880,19
	LA02		102,00	1.437,25	2.880,19
Area2		435,00	0,00	435,00	0,00
	AM	375,00	0,00	435,00	0,00
	JP	60,00	0,00	435,00	0,00

Which are the correct formula to the both measures?

Thank you.

Forum Discussion

remove duplicate value within a row

Matrix Row Totals within Row Values

Total in Matrix with values on row

DAX total != total rows

custom total row