Forum Discussion
Solved
Even with relationship, pibot table field always shows SUM
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 dupl...
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
Could you provide small sample of source data (few records for each table is enough) ?
Done, thank you.
Where is it?
- I've added it in the end of my post.
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