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

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

Hello,

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

Thanks.

 

Floriankx's avatar
Floriankx
Icon for Solution Sage rankSolution Sage
8 years ago

Please give us some sample data of your Table1.

 

Best regards