Forum Discussion

PKPK90's avatar
PKPK90
Icon for Helper I rankHelper I
3 years ago

Totals from SummarizeColumns

Hi, I have created new table  SupplyDemandPerSiteItem = SUMMARIZECOLUMNS(     DistinctTable[Site],     DistinctTable[ItemKey],     "Demand",MAX(DistinctTable[RunningRequirement]),     "Supply...
"DAX"
Anil_kapkoti's avatar
Anil_kapkoti
New Member
3 years ago

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's avatar
    PKPK90
    Icon for Helper I rankHelper I
    3 years ago

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