Create a new column based on values of two columns, but matching based on certain column

[rclay78]

I have been trying to figure this out and have failed. I have tried New Column = Calculate('table1'[Column1], 'table1'[Column2] in {1}), but it only duplicated whats in Column 2. I basically just want to create a new column where it returns a 1 if any row >=1 for the same Column1 value. 

Column1	Column2	New Column
11AA	1	1
11AA	2	1
11AA	1	1
11AA	0	1
11B2	0	0
11B2	0	0
2222	1	1
2222	0	1
3333	0	0
3333	0	0
4444	1	1
4444	3	1

[Anonymous · Accepted solution]

@rclay78 

You may create this column: 

Column = IF(CALCULATE(MAX([Column2]),ALLEXCEPT('Table','Table'[Column1]))>=1,1,0)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@rclay78 , Create a new column like

new column =
var _cnt = countx(filter(Table, [Column1] = earlier([Column1]) && [Column2]>=1), [Column1])
return
if(isblank([_cnt]),0,1)