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"
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

Thanks, I am receiving error message like:

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