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

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

Hello,

 

can you show us the structure of your raw data?

Your Measures should work perfectly.

 

I created this RawTable:

AreaConcepte FACTCostFact
Area1AM           25,00   
Area1EC           20,00   
Area1JS     1.160,00   
Area1MP           35,00   
Area1MR         137,00   
Area1RC           60,00   
Area1LA01      2.778,19  
Area1LA02          102,00  
Area2AM3750
Area2JP600

 

I created the following Measures:

Cost_:=SUM(Table1[Cost])

TemCOST:=CALCULATE([Cost_];ALL(Table1[Concepte FACT]))

 

Fact_:=SUM(Table1[Fact])

TempFACT:=CALCULATE([Fact_];ALL(Table1[Concepte FACT]))

 

And this is my result:

  • Raul's avatar
    Raul
    Post Patron
    8 years ago

    Hi Floriankx, thank you for your reply.

    This is the relationship between tables in the data model:

     

    Thank you!

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

        Hello,

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

        Thanks.