Please help me on below scenario

[aditya369]

hi team,please help me on this.

Invoice ID	Invoice	QTY	Received	3way/No	Final Result
123	1	1	1	3way	no
123	0	1	0	No	no
123	0	0	0	3way	no
124	0	0	0	3way	3way
124	0	0	0	3way	3way
124	1	1	1	3way	3way

Note : i need final Result column as the output.

Condition : if the invoice ID = 123 and any one of that ID row  exist in 3way/No = No then entire rows of that ID should "no" otherwise 3way.

please help me on this.TIA.

[Watsky]

Hey @aditya369 ,

Try this 

Final Result = IF('Table'[Invoice ID]=123,if('Table'[3way/No] = "No","no","no"),"3way")

[aditya369]

Hi,thanks for the response. i have too many rows with different id's so i need solution in dynamically not in static.can you please modify the code.

[Watsky · Accepted solution]

Okay,

Final Result = 
VAR c =
    COUNTROWS (
        FILTER (
            'Table',
            EARLIER ( 'Table'[Invoice ID] ) = 'Table'[Invoice ID]
                && 'Table'[3way/No] = "No"
        )
    )
RETURN
    IF ( c = 1, "no", "3way" )

Next time please make sure to give all of your conditions in your initial request so that we can get the full extent of what you're trying to do.

[aditya369]

Thank you so much watsky for the quick response and thanks for the support.

[Watsky]

It's my pleasure! I'm happy I could find a solution for you!