Forum Discussion
Solved
Create an aggregate column
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
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.
2 Replies
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.
Thank you, it's what i wanted !
