Total in Matrix

[Alexo3627]

Hello my friends.

I Try to add the same value from total in new column, in matrix.

I´ve two rows: Region (EEUU, EUROPA), and Cities (CA.LA,MI,MA,PA,PO); two columns (Last Sales, Act Sales).

in the new columns, needs to add Last Sales and Act Sales.

Regards.

[MFelix · Accepted solution]

HI @Alexo3627 

You need to create two measures similar to this:

General Act = CALCULATE( SUM(Table[Act Sales]), REMOVEFILTERS(Table[Region], Table[Cities]))

General Last = CALCULATE( SUM(Table[Last Sales]), REMOVEFILTERS(Table[Region], Table[Cities]))