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

Floriankx's avatar
Floriankx
Icon for Solution Sage rankSolution 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.

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.