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

Hi Anonymous

Your exemple it's awesome :smileysurprised:, thanks a lot. This is exactly what I want and the two matrix tables present the correct results. 

 

But, I changed the conditional column by the calculated column concatenating the two fields as Floriankx commented and the result, in my case, is still incorrect. It's the same as I had with the conditional column and I can not show the totals by Area in the whole column.

 

What's happens? :smileysad: