Create an aggregate column

[JbPa33]

Hello,

I am working on Power BI et i would like to create an aggregate column :

On Power BI, I have a table with the first 3 columns and I would like to create the green column. I tried with the formula 'SUMMARIZE' but i have an error.

Any ideas ?

Thank you 

[jdbuchanan71 · Accepted solution]

@JbPa33 

You can use a formula like this

Sum by vendor = 
CALCULATE ( SUM ( 'YourTable'[Sum] ), ALLEXCEPT ( 'YourTable', 'YourTable'[Vendor] ) )

You will need to change the table and field names to match your model.

[JbPa33]

Thank you, it's what i wanted !