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

 

Table 1

NumberNameGroupCategoryIsparent
Apple001Apple FruitYes
132112Apple ItalyAppleFruitNo
122131Apple FranceAppleFruitsNo

 

Result

NumberNameGroupCategoryResult
Apple001Apple Fruit 
132112Apple ItalyAppleFruitTRUE
122131Apple FranceAppleFruitsFALSE
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

1 Reply

  • 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