Forum Discussion

LeahZhang's avatar
LeahZhang
Microsoft Employee
4 years ago
Solved

SUMX Calculation

  Dear Team,    Thanks for your prompt and continious support. I am fresh new to DAX, and seek team advise on the below mismatch:   Two Measure Are: totalScore #1 = SUMX ( VALUES ( 'Config ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Try:

    totalscore =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( Table, Table[GHG item], Table[Plant] ),
        "TScore", [Emission Factor] * [Input]
    ),
    [Tscore]
)
amitchandak's avatar
amitchandak
Super User
4 years ago

LeahZhang , Ideally multiplcation should happen at rows level like column or measure like

 

new column = [A]* [B]

new measure = sumx(Table, [A]*[B])

 

If we need to multiply two measures, not from the same table then you should most granular level using values or summarize(more than one column)