Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everybody,
I'd like to ask you to help me with a DAX formula.
I have this situation
I need to get the formula for the yellow Requested column.
The logic is following:
I need to calculate all hours of every user that are not _Attendance
Thank you in advance.
Solved! Go to Solution.
Try this Column
Requested = CALCULATE ( SUM ( TableName[Hours] ), FILTER ( ALLEXCEPT ( TableName, TableName[User] ), TableName[Project category] <> "_Attendance" ) )
Try this Column
Requested = CALCULATE ( SUM ( TableName[Hours] ), FILTER ( ALLEXCEPT ( TableName, TableName[User] ), TableName[Project category] <> "_Attendance" ) )
Worked perfectly, than you, Muhammad
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |