Forum Discussion

karvMe's avatar
karvMe
Copper Contributor
Mar 28, 2023
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...
excel
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 31, 2023

    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

     

     

karvMe's avatar
karvMe
Copper Contributor
Mar 31, 2023
I've added it in the end of my post.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 31, 2023

    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

     

     

Resources