Totals from SummarizeColumns

[PKPK90]

Hi, I have created new table 

SupplyDemandPerSiteItem =

SUMMARIZECOLUMNS(

    DistinctTable[Site],

    DistinctTable[ItemKey],

    "Demand",MAX(DistinctTable[RunningRequirement]),

    "Supply",MAX(DistinctTable[RunningReception]))

from this table I want to get
SupplyDemandPerItem=
SUMMARIZECOLUMNS(

   SupplyDemand[ItemKey],

  "Demand",SUM(Demand),

  "Supply",SUM(Supply))

Is it possible to to achieve the same result but in the first table?
I don't want to create two tables if it's not necessary.

[Anil_kapkoti]

Check this one
SupplyDemandPerItem =
VAR DemandTable =
SUMMARIZE(
DistinctTable,
DistinctTable[Site],
DistinctTable[ItemKey],
"Demand", MAX(DistinctTable[RunningRequirement])
)
VAR SupplyTable =
SUMMARIZE(
DistinctTable,
DistinctTable[Site],
DistinctTable[ItemKey],
"Supply", MAX(DistinctTable[RunningReception])
)
RETURN
SUMMARIZECOLUMNS(
DistinctTable[ItemKey],
"Demand", SUMX(DemandTable, [Demand]),
"Supply", SUMX(SupplyTable, [Supply])
)

[PKPK90]

Hi, I am receiving the same values for every Item.

[v-tangjie-msft]

Hi @PKPK90 ,

Please try:

SupplyDemandPerItem =
SUMMARIZECOLUMNS(
    DistinctTable[ItemKey],
    "Demand", SUMX(SUMMARIZECOLUMNS(
        DistinctTable[Site],
        DistinctTable[ItemKey],
        "Demand", MAX(DistinctTable[RunningRequirement])
    ), [Demand]),
    "Supply", SUMX(SUMMARIZECOLUMNS(
        DistinctTable[Site],
        DistinctTable[ItemKey],
        "Supply", MAX(DistinctTable[RunningReception])
    ), [Supply])
)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[PKPK90]

Thanks, I am receiving error message like:

SummarizeColumns() and AddMissingItems() may not be used in this context.