How to create get a desired Value from a filtered result and change all the rows

[asunkavalli]

Hi,

I am trying to change or input a value based on the filtered result and then look at all the rows. 

For example:

As you can see below, ID 1 and item 10 may have different possible CONCAT2 values and the trasnformed value of X Y Z, if the result in the CHECK = TRUE, then I want all the lines since they are ID: 1 and ITEM: 10, the desired result for all rows to be "GOOD"

If you see ID: 3 and Item 10, it has both the CHECK as False, so I want all the lines in the desired result to show up as "NOT GOOD" for those 2 rows with ID 3 and Item 10. 

ID	ID ITEM	CONCAT 2	CONCAT3	CHECK	Desired Result
1	10	A	X	FALSE	GOOD
1	10	B	Y	FALSE	GOOD
1	10	C	Z	TRUE	GOOD
2	10	D	X	FALSE	GOOD
2	10	E	Z	TRUE	GOOD
3	10	F	X	FALSE	NOT GOOD
3	10	G	Y	FALSE	NOT GOOD

I am trying to find out how I can do this in PowerBI, any suggestions? 

[v-frfei-msft · Accepted solution]

Hi @asunkavalli ,

Sample for your reference.

RESULT = 
VAR result =
    CONTAINS (
        FILTER (
            Table1,
            Table1[ID] = EARLIER ( Table1[ID] )
                && Table1[ID ITEM] = EARLIER ( Table1[ID ITEM] )
        ),
        Table1[CHECK], TRUE ()
    )
RETURN
    IF ( result = TRUE (), "GOOD", "NOT GOOD" )

[asunkavalli]

WOW you are a genius sir! Thank you! I really appreciate your help! It worked magically.