Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
NPR
Frequent Visitor

How to get specific values of each project ?

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 

ee.png


I need a cloumn like this 

er.png

How to create by dax query ? 

1 ACCEPTED SOLUTION
NPR
Frequent Visitor

 

 This is the correct solution for it Smiley Very Happy

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

View solution in original post

2 REPLIES 2
NPR
Frequent Visitor

 

 This is the correct solution for it Smiley Very Happy

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

Anonymous
Not applicable

Hi @NPR 

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

Good luck!
A

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.