Forum Discussion

Jruiz218's avatar
Jruiz218
Frequent Visitor
6 years ago
Solved

Help With Formula TRUE / FALSE / NULL

Hello Everyone,   Im new with DAX and im looking help to build a formula for the following scenario, PowerPivot data model with two tables:   Table A has the following fields: UniqueID Date Te...
Need Help
Tips and Tricks
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Please try this expression for your calculated column on the TeamA table.  Note that I had a 1:1 relationship between them, so you will have to adapt this to RELATEDTABLE() if TeamB is on the many side.

     

    Result =
    VAR existsB =
    NOT ( ISBLANK ( RELATED ( TableB[UniqueID] ) ) )
    VAR teamX = TableA[Team] = "X"
    RETURN
    SWITCH ( TRUE (), AND ( existsB, teamx ), "TRUE", existsB, "FALSE", "NULL" )

     

    Result =
    VAR existsB =
    NOT ( ISBLANK ( RELATED ( TableB[UniqueID] ) ) )
    VAR teamX = TableA[Team] = "X"
    RETURN
    SWITCH ( TRUE (), AND ( existsB, teamx ), "TRUE", existsB, "FALSE", "NULL" )

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Please try this expression for your calculated column on the TeamA table.  Note that I had a 1:1 relationship between them, so you will have to adapt this to RELATEDTABLE() if TeamB is on the many side.

 

Result =
VAR existsB =
NOT ( ISBLANK ( RELATED ( TableB[UniqueID] ) ) )
VAR teamX = TableA[Team] = "X"
RETURN
SWITCH ( TRUE (), AND ( existsB, teamx ), "TRUE", existsB, "FALSE", "NULL" )

 

Result =
VAR existsB =
NOT ( ISBLANK ( RELATED ( TableB[UniqueID] ) ) )
VAR teamX = TableA[Team] = "X"
RETURN
SWITCH ( TRUE (), AND ( existsB, teamx ), "TRUE", existsB, "FALSE", "NULL" )

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • Jruiz218's avatar
    Jruiz218
    Frequent Visitor
    6 years ago

    Thank you very much mahoneypat  it worked just fine!