topic Re: How to qualify a product based on a characteristic in DAX Commands and Tips

How to qualify a product based on a characteristic

Paskk — Thu, 10 Aug 2023 23:09:00 GMT

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

Re: How to qualify a product based on a characteristic

some_bih — Fri, 11 Aug 2023 07:15:47 GMT

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"

)

Re: How to qualify a product based on a characteristic

Paskk — Fri, 11 Aug 2023 07:32:09 GMT

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

Re: How to qualify a product based on a characteristic

Paskk — Fri, 11 Aug 2023 08:03:10 GMT

Sorry, now it works. Great! Thank you again

Re: How to qualify a product based on a characteristic

some_bih — Fri, 11 Aug 2023 09:12:58 GMT

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