Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 ?
Solved! Go to Solution.
This is the correct solution for it
ProjectWithheadCount = CALCULATE(DISTINCTCOUNT(sourceTable[headcount]), ALLEXCEPT(sourceTable, sourceTable[Project]))
This is the correct solution for it
ProjectWithheadCount = CALCULATE(DISTINCTCOUNT(sourceTable[headcount]), ALLEXCEPT(sourceTable, sourceTable[Project]))
User | Count |
---|---|
136 | |
70 | |
69 | |
54 | |
52 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |