If row contains specific value, mark multiple rows with the same ID

[Henrik_PBI]

Hi,

I have a table with Order IDs, where each Order ID can have mulitple rows. Some or more of these rows can have a "1" in the column "external". If a order_id is marked as external in one or more rows, I want to mark all rows in a new colum (Order_external) with "1". If a order number doesn't have a "1" in the column External, it should be 0 in the new column. See example below:

Here I have 3 rows for order_id 1456 (red), and one of the rows is marked as 1 in column External (blue). What I want is to create a new column (Order_external) and mark all the rows for order_id 1456 as 1 (yellow). For orders with only 0's in External column, the new column should show 0 for all rows (example: order_id 1502).

I havent been able to create this new column, can anyone help me out?

[Fowmy · Accepted solution]

@Henrik_PBI 

Order External= 

IF( 
    CALCULATE( MAX(Table[External]) ,ALLEXCEPT(Table,Table[Order ID] )) > 0,
    1,
    0
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Henrik_PBI]

Thanks @Fowmy , just what I needed!