How to qualify a product based on a characteristic

[Paskk]

In the table I would like to be able to create a new column to qualify "Product" as "processed" if all the rows of "Product" are "processed" in the "Stato_Ven" column. Thank you

Product	Colour	Customer	Sell	Stato_Ven	N_Order
A	Blu	Pippo	100000,00	Processed	1
B	Giallo	Franco	50000,00	Not processed	2
C	Verde	Caio	60000,00	Processed	3
E	Rosso	Sempronio	90000,00	Processed	5
G	Nero	Coco	80000,00	Processed	7
A	Blu	Pippo	20000,00	Not processed	8
B	Giallo	Franco	50000,00	Processed	9
C	Verde	Caio	60000,00	Processed	10
E	Rosso	Sempronio	90000,00	Processed	12
G	Bianco	Coco	80000,00	Not processed	14

[some_bih · Accepted solution]

Hi @Paskk please create calculated column as following and replace table name "Sheet1" with your table name.

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Status_Test =

IF(

    COUNTROWS(

        FILTER(

            Sheet1,

            Sheet1[Product] = EARLIER(Sheet1[Product]) &&

            Sheet1[Stato_Ven] = "Processed"

        )

    ) = COUNTROWS(

        FILTER(

            Sheet1,

            Sheet1[Product] = EARLIER(Sheet1[Product])

        )

    ),

    "Processed",

    "Not processed"

)

[Paskk · Accepted solution]

Thanks, your solution is perfect, but when I use it in my table it doesn't work. Can you tell me why? Thanks again

[Paskk · Accepted solution]

Sorry, now it works. Great! Thank you again

[some_bih · Accepted solution]

Hi @Paskk please create calculated column as following and replace table name "Sheet1" with your table name.

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Status_Test =

IF(

    COUNTROWS(

        FILTER(

            Sheet1,

            Sheet1[Product] = EARLIER(Sheet1[Product]) &&

            Sheet1[Stato_Ven] = "Processed"

        )

    ) = COUNTROWS(

        FILTER(

            Sheet1,

            Sheet1[Product] = EARLIER(Sheet1[Product])

        )

    ),

    "Processed",

    "Not processed"

)

[Paskk · Accepted solution]

Thanks, your solution is perfect, but when I use it in my table it doesn't work. Can you tell me why? Thanks again

[Paskk · Accepted solution]

Sorry, now it works. Great! Thank you again

[some_bih · Accepted solution]

@Paskk please accept as solution so other member of community could see it. thank you