Calculated Column If with filter

[joshua1990]

Hi experts!

I have a table that shows me for all orders mutiple rows with different values:

Order	State	Key	Value
100	A	A1	50
100	B	A1	60
101	A	A1	40

Here I would like to add a calculated column that returns for each order (there are mutpliple rows per order) true the order has any entry with 

• State = 'A'
• Key = 'A1'

How is that possibleas a calculated column?

[amitchandak · Accepted solution]

@joshua1990 . Not very clear

New column =

var _cnt = countx(filter(Table, [Order] =earlier([Order]) && [State] = "A" && [Key] ="A1") , [Order])

return

if(isblank(_cnt), false() , True() )