Calculated Column If with filter

joshua1990 — Mon, 25 Jul 2022 08:19:50 GMT

Hi experts!

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

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

How is that possibleas a calculated column?

Re: Calculated Column If with filter

amitchandak — Mon, 25 Jul 2022 08:40:37 GMT

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() )