Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated Column Identifier based on if a particular condition is satisfied in Data Table

Hi all, it's hard to put into words for the title what I'm looking for, but (hopefully) simpler in the DAX Really, what I'm looking to do is create a calculated column in my lookup table that wi...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    According to your description, I modify your sample data.

    Table1:

    Here's my solution. Create a calculated column.

    Multi-Part Person =
IF (
    SUMX (
        FILTER (
            'Table1',
            'Table1'[User Record] = EARLIER ( Table2[User Record] )
                && 'Table1'[Action Parts] <> 1
        ),
        'Table1'[Action Parts]
    ) > 0,
    TRUE,
    FALSE
)

    Get the correct result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

Hi Anonymous ,

 

How about this:

 

Here the DAX code for the calculated column:

Multi-Part Person = 
IF ( 
    Table34b[User Record] in ( FILTER ( VALUES ( Table34a[User Record] ), CALCULATE ( SUM ( 'Table34a'[Action Parts] ) > 0 ) ) ), 
    TRUE, 
    FALSE 
)

Let me know if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/