Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
2 years ago
Solved

Assistance needed with Measure

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   Ta...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

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