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

Here you are:

 

DATECODAREACOLCONCEPTECOSTFACTCONCEPTE FAC
11/05/2017A1AM            10,00   AM
24/06/2017A1EC              5,00   EC
05/07/2017A2AM            12,00   AM
06/07/2017A3JS            11,00   JS
01/01/2017A1MP            25,00   MP
28/02/2017A2MR            13,00   MR
15/03/2017A1 LA01          200,00  LA01
20/08/2017A1RC            14,00   RC
11/05/2017A2MP            25,00   MP
11/04/2017A2EC            32,00   EC
10/02/2017A3AM            44,00   AM
04/01/2017A3 LA01          360,00  LA01
31/03/2017A1 LA02          175,00  LA02
20/06/2017A2JS            27,00   JS

 

And the Areas table:

 

CODAREAAREA
A1Area1
A2Area2
A3Area3

 

Thank you.

Pavlous's avatar
Pavlous
Advocate 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
    Post 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.