Forum Discussion

Post Patron

8 years ago

Solved

Total value for all rows

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 ...

Raul
8 years ago
I've found the solution!!!
The formula for the measure is:
TempCOST = CALCULATE(SUM(Table1[Cost]);ALLSELECTED(Table1);VALUES(Table1[Area]))

Thank you Anonymous, Pavlous and Floriankx for your help.
Bye!!

Solution Sage

8 years ago

Hello,

relationship doesn't seem to be the problem, as long as CodArea columns are related properly and CodArea is unique in your AREAS Table.

It still should work.

You can try to use CodArea of Table1 instead of Area of the AREAS Table and see if something changes.

Best regards.

Post Patron

8 years ago

Hello,

I tried your response but the result is the same. What I can do?

Thanks.

Solution Sage

8 years ago

Please give us some sample data of your Table1.

Best regards

Post Patron

8 years ago

Here you are:

DATE	CODAREA	COL	CONCEPTE	COST	FACT	CONCEPTE FAC
11/05/2017	A1	AM		10,00		AM
24/06/2017	A1	EC		5,00		EC
05/07/2017	A2	AM		12,00		AM
06/07/2017	A3	JS		11,00		JS
01/01/2017	A1	MP		25,00		MP
28/02/2017	A2	MR		13,00		MR
15/03/2017	A1		LA01		200,00	LA01
20/08/2017	A1	RC		14,00		RC
11/05/2017	A2	MP		25,00		MP
11/04/2017	A2	EC		32,00		EC
10/02/2017	A3	AM		44,00		AM
04/01/2017	A3		LA01		360,00	LA01
31/03/2017	A1		LA02		175,00	LA02
20/06/2017	A2	JS		27,00		JS

And the Areas table:

CODAREA	AREA
A1	Area1
A2	Area2
A3	Area3

Thank you.

Floriankx
Solution Sage
8 years ago
Hello, I guess CONCEPTE FAC is a calculated column.

If it is any if statement maybe try
CONCATENATE([COL],[CONCEPTE]) instead.

Best regards