Forum Discussion

Raul's avatar
Raul
Icon for Post Patron rankPost 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   ...
Need Help
  • Raul's avatar
    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!!

Pavlous's avatar
Pavlous
Icon for Advocate II rankAdvocate II
8 years ago

Hi,

it would be heplfull if you show us what is your result at that moment. So we can think what you are doing wrong :)

Raul's avatar
Raul
Icon for Post Patron rankPost Patron
8 years ago

Hi,

This is the result:

 

   

 

And this are the measures:

TempCOST = CALCULATE(SUM(Table1[Cost]);ALL(Table1[Concepte FAC]))

TempFACT = CALCULATE(SUM(Table1[Fact]);ALL(Table1[Concepte FAC]))

 

Regards.