CALCULATED COLUMN Check if order records contains value

[joshua1990]

Hi all!

I have a table that contains for each order mutliple rows:

Order	Value	Check
100	A	TRUE
100	B	TRUE
100	C	TRUE
101	A	FALSE

Now I would like to add a calculated column (Check), that shows me per Order Number (TRUE /FALSE) if the Order contains a "C" record.

How would you do that as a calculated column?

[SpartaBI · Accepted solution]

@joshua1990 
If I understood what you want so something like this:

Column = 
VAR _current_order = Table[Order]
VAR _list = 
    CALCULATETABLE(
        VALUES(Table[Value]),
        REMOVEFILTERS(Table),
        Table[Order] = _current_order
    )
VAR _check = 
    CONTAINS(_list, Table[Value], "C")
RETURN
    _check

In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂