How to get specific values of each project ?

[NPR]

Hi Guys, I am new to powerBi ! 

I show my requirements below.............! please check them up

This is my table..... Here each project has separate headcount values itself. For example, Project A -> 8  Project B -> 1 

I need a cloumn like this 

How to create by dax query ? 

[NPR · Accepted solution]

 This is the correct solution for it

ProjectWithheadCount = CALCULATE(DISTINCTCOUNT(sourceTable[headcount]), ALLEXCEPT(sourceTable, sourceTable[Project])) 

[Anonymous]

Hi @NPR 

Look at countrows(), with earlier() Filter.

Good luck!
A