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.

       

      • Floriankx's avatar
        Floriankx
        Solution Sage
        8 years ago

        Please give us some sample data of your Table1.

         

        Best regards