topic Re: Totals from SummarizeColumns in DAX Commands and Tips

Totals from SummarizeColumns

PKPK90 — Tue, 01 Aug 2023 11:43:46 GMT

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.

Re: Totals from SummarizeColumns

Anonymous — Wed, 02 Aug 2023 02:45:42 GMT

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.

Re: Totals from SummarizeColumns

PKPK90 — Mon, 07 Aug 2023 13:24:40 GMT

Thanks, I am receiving error message like:

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

Re: Totals from SummarizeColumns

Anil_kapkoti — Mon, 07 Aug 2023 17:28:24 GMT

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])
)

Re: Totals from SummarizeColumns

PKPK90 — Tue, 08 Aug 2023 08:41:24 GMT

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