Help with Table

[Anonymous]

Hi, I have a table like this:

I want another column which tells me if a ticket id has at least one incoming mail (all 1 in these ticket)

For example in ticket 827545 i want 1 in all the rows because in one row it has 1 incoming mail.

Thank you

[Mariusz · Accepted solution]

Hi @Anonymous ,

You can add this column.

Column = 
IF( 
    CALCULATE(
        COUNTROWS( YourTable ),
        ALLEXCEPT( YourTable, YourTable[ticket_id] ),
        YourTable[incoming mails] = 1
    ) > 0, 1, 0
)

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.