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]
)
PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Try:

totalscore =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( Table, Table[GHG item], Table[Plant] ),
        "TScore", [Emission Factor] * [Input]
    ),
    [Tscore]
)