Even with relationship, pibot table field always shows SUM

[karvMe]

I'm trying to create a pivot table from two tables.

The first table (Table1) has a unique column "HOST" and informations about that host

and the second (Table2) has the same column but with duplicates and has informations about the contents of the host. One of thos column is called "tomcat"

What I want is to create a dynamic pivot table to show for every "tomcat" has how much "hosts" and for every host show how much ram it has.

Example : 

but As u see here Ram column has the same value everywhere.

 

I created relationships between the two tables, I added a bridge table, ... nothing works.

EDIT : 

Table Hosts :

HOST	NB_CPU	RAM	RAM_USED
batchs	2	10113984	7712892
cms1	1	3916900	3558896
cms2	1	3924196	2572340

Table tomcat :

HOST	TOMCAT	XMX	XMS	PERMGEN	JMX_PORT
batchs	tomcat21	512m	512m	256m	9210
batchs	tomcat70	512m	512m	256m	9700
cms1	tomcat25	512m	512m	256m	9250

[#2]

@karvMe 

Could you provide small sample of source data (few records for each table is enough) ?

[#3]

Done, thank you.

[#4]

@karvMe 

Where is it?

[#5]

I've added it in the end of my post.

[#6 · Accepted solution]

@karvMe 

See it, thank you.

So, we add both Hosts and Tomcat tables to data model and create relationship:

To calculate from many-to-one we may create the measure for RAM available

tomcat ram:=CALCULATE( SUM( Hosts[RAM] ), CROSSFILTER( Hosts[HOST], tomcat[HOST], Both ) )

and create PivotTable from data model

Please see in attached file