Assistance needed with Measure

[gauravnarchal]

Need assistance with the measure to get the result as per below 

If the Group column matches the Name column and the Category of Name & Group is the same then return True else return false

Table 1

Number	Name	Group	Category	Isparent
Apple001	Apple		Fruit	Yes
132112	Apple Italy	Apple	Fruit	No
122131	Apple France	Apple	Fruits	No

Result

Number	Name	Group	Category	Result
Apple001	Apple		Fruit
132112	Apple Italy	Apple	Fruit	TRUE
122131	Apple France	Apple	Fruits	FALSE

[Greg_Deckler · Accepted solution]

@gauravnarchal If I understand, correctly, try the following PBIX is attached below signature.

Measure = 
    VAR __Name = MAX('Table'[Name])
    VAR __Group = MAX('Table'[Group])
    VAR __Category = MAX('Table'[Category])
    VAR __Table = FILTER(ALL('Table'), [Isparent] = "Yes" && [Name] = __Group)
    VAR __ParentCategory = MAXX(__Table, [Category])
    VAR __ParentGroup = MAXX('Table', [Group])
    VAR __Result = 
        SWITCH( TRUE(), 
            __Group = BLANK(), BLANK(),
            __Group = __ParentGroup && __Category = __ParentCategory, TRUE(),
            FALSE()
        )
RETURN
    __Result