creating a calculated column based on another column

[Fali324]

Hi,

I am trying to create a calculated column to sum another column. Here is some example data of what I am trying to produce:

Project Name	Product	Cost	Total Project Cost	Percentage
Project A	car	£1,000.00	£7,000.00	14%
Project A	bus	£1,000.00	£7,000.00	14%
Project A	hat	£1,000.00	£7,000.00	14%
Project A	glass	£1,000.00	£7,000.00	14%
Project A	cup	£1,000.00	£7,000.00	14%
Project A	car	£1,000.00	£7,000.00	14%
Project A	bus	£1,000.00	£7,000.00	14%
Project B	hat	£2,000.00	£8,000.00	25%
Project B	car	£2,000.00	£8,000.00	25%
Project B	bus	£2,000.00	£8,000.00	25%
Project B	hat	£2,000.00	£8,000.00	25%

I had the data in red text, I am trying to calculate total project cost so I can then work out the percentage. what is the best way to do this. Any help is much appreciated.

[Ritaf1983 · Accepted solution]

Hi @Fali324 

For total project you can use dax :

Total_project_Rita = CALCULATE(sum('Table'[Cost]),ALLEXCEPT('Table','Table'[Project Name]))

for percent

%_Rita = [Cost]/[Total_project_Rita]

PBIX is attached

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly