Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Total in Matrix

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...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    HI Anonymous 

     

    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]))
MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

HI Anonymous 

 

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]))