Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX Column value conditional on multiple rows

I have a joined table of opportunities and products grouped by product line, e.g.    Opp | Product Line A     |   X B     |   Y C     |   X C     |   Y D    |   Z   I'm interested in being a...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Anonymous

     

    Try this Column

     

    OppContainsXandY =
VAR Mytable =
    FILTER ( TableName, TableName[Opp] = EARLIER ( TableName[Opp] ) )
RETURN
    IF (
        CONTAINS ( mytable, TableName[Product Line], "X" )
            && CONTAINS ( mytable, TableName[Product Line], "Y" ),
        "Yes",
        "No"
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Anonymous

 

Try this Column

 

OppContainsXandY =
VAR Mytable =
    FILTER ( TableName, TableName[Opp] = EARLIER ( TableName[Opp] ) )
RETURN
    IF (
        CONTAINS ( mytable, TableName[Product Line], "X" )
            && CONTAINS ( mytable, TableName[Product Line], "Y" ),
        "Yes",
        "No"
    )
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Zubair_Muhammad

 

Your solution works great - thank you!