Summarizing data

[Anonymous]

Dear Power BI users,

I have a question about the below mentioned table (ORIGINAL TABLE).

as you can see we have several lines per container_nr..

Some lines do have a S01 in the colums code_cod, some not

I am looking for for a formula/ filter wich gives me a summary of the order_nr & container_nr and a YES if in the original table a line is present with S01 in the colum code_cod.

Thanks for your kind help!

John

RESULT TABLE:

order_nr	container_nr	foto_fee_in_estimate
8837312	TTNU8968305	YES
8843422	TTNU8967839	YES
8281616	TTNU8967280	YES
8824972	TTNU8965564	NO
8814244	TTNU8965121	NO
8826854	TTNU8612361	NO
8821072	TTNU8610121	NO

ORIGINAL TABLE:

order_nr	container_nr	code_cod
8837312	TTNU8968305	A01
8837312	TTNU8968305	S01
8843422	TTNU8967839	A03
8843422	TTNU8967839	A04
8843422	TTNU8967839	S01
8281616	TTNU8967280	D09
8828579	TTNU8967280	D09
8281616	TTNU8967280	S01
8824972	TTNU8965564	B08
8824972	TTNU8965564	E51
8814244	TTNU8965121	A03
8826854	TTNU8612361	A01
8821072	TTNU8610121	A01

[Anonymous · Accepted solution]

This should work:

Table = 
SUMMARIZE(
    Table1,
    Table1[order_nr],
    Table1[container_nr],
    "foto_fee_in_estimates",
    If(
        CALCULATE(
            COUNTROWS(Table1),
                Table1[code_cod]="S01") >=1,
                "Yes","No"
    )
)

[Anonymous]

Good morning Nick,

Thanks, works oke for me!

Regards,

John