Forum Discussion

Raul's avatar
Raul
Post 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
Post Patron
8 years ago

A difference between your Table1 or Merge1 origin table and my table are that the values of the rows for the Cost and Fact columns are null intead of blank that your exemple.

 

Merge1

My table.

 

Could this be the problem? Thank you.

Raul's avatar
Raul
Post Patron
8 years ago

No, that is not the problem. I have changed the null values by 0 and the result is still incorrect:

 

Please, help me!!!!!

  • Raul's avatar
    Raul
    Post Patron
    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!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Raul,

     

    Can you help me, how to display same row number in total based on category. that's my current problem.