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

Hello,

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

Thanks.

 

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

Please give us some sample data of your Table1.

 

Best regards

  • 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.

    • Floriankx's avatar
      Floriankx
      Solution Sage
      8 years ago

      Hello, I guess CONCEPTE FAC is a calculated column.

       

      If it is any if statement maybe try

      CONCATENATE([COL],[CONCEPTE]) instead.

       

      Best regards

      • Pavlous's avatar
        Pavlous
        Advocate II
        8 years ago

        Yes, in this case it could be the issue in Axis value. Try to make Table only with Raw attributes and the measure during the date. It should give you the result. The formulas are perfectly OK.

    • 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.