Calculating based on filtering column values

[Murkow]

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.

[Zubair_Muhammad · Accepted solution]

@Murkow

Try this Column

Requested =
CALCULATE (
    SUM ( TableName[Hours] ),
    FILTER (
        ALLEXCEPT ( TableName, TableName[User] ),
        TableName[Project category] <> "_Attendance"
    )
)

[Murkow]

Worked perfectly, than you, Muhammad