Forum Discussion

Etienne_1995's avatar
Etienne_1995
Frequent Visitor
2 years ago
Solved

summarize value by grouping

Hi there   I'd like to get the sum of the Column "Investment Budget Nr", without beeing split up into the value from the column "ID". I tried it with SUMX and SUMMARIZE, but it still showed up the...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Etienne_1995 ,

     

    I made simple samples and you can check the results below:

    Total by Nr = var _t = ADDCOLUMNS('Table',"Total by Nr",SUMX(FILTER(ALL('Table'),[Investment Budget Nr]=EARLIER([Investment Budget Nr])),[Effective Price]))
RETURN SUMX(_t,[Total by Nr])

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Etienne_1995 ,

 

I made simple samples and you can check the results below:

Total by Nr = var _t = ADDCOLUMNS('Table',"Total by Nr",SUMX(FILTER(ALL('Table'),[Investment Budget Nr]=EARLIER([Investment Budget Nr])),[Effective Price]))
RETURN SUMX(_t,[Total by Nr])

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.