Forum Discussion
Raul
Post Patron
Post PatronTotal 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 ...
Floriankx
Solution Sage
Solution SageHello,
can you show us the structure of your raw data?
Your Measures should work perfectly.
I created this RawTable:
| Area | Concepte FACT | Cost | Fact |
| Area1 | AM | 25,00 | |
| Area1 | EC | 20,00 | |
| Area1 | JS | 1.160,00 | |
| Area1 | MP | 35,00 | |
| Area1 | MR | 137,00 | |
| Area1 | RC | 60,00 | |
| Area1 | LA01 | 2.778,19 | |
| Area1 | LA02 | 102,00 | |
| Area2 | AM | 375 | 0 |
| Area2 | JP | 60 | 0 |
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:
RaulPost Patron
Post PatronHi Floriankx, thank you for your reply.
This is the relationship between tables in the data model:
Thank you!
- Floriankx
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.