Forum Discussion

sc27's avatar
sc27
Frequent Visitor
5 years ago

Help removing specific values tied to a shared ID value

Hello,

 

I have a large dataset where a number of records are connected via unique IDs. I want to be able to see the associated attributes across all ID's and remove specific values.

 

To simplify it, I want to check for where an ID has more than 1 Account related to it. If it does, and that Account name is John, I do not want to include it within a separate concatenate measure.

 

I'd want my CONCATENATEX for Account, State and Level to give me this result

Is this even possible? 

6 Replies

    • sc27's avatar
      sc27
      Frequent Visitor
      5 years ago

      Thanks, but that's not exactly what I need. I have a scenario where I need the remove a specifc value and its associated column values based on a logical condition. Then, take that result and conduct a separate concatenation

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, sc27 

    Please check the link down below.

     

     

    Account Name(s) Measure =
    IF (
    ISFILTERED ( 'Table'[ID] ),
    CONCATENATEX (
    SUMMARIZE ( FILTER ( 'Table', 'Table'[Account] <> "John" ), 'Table'[Account] ),
    'Table'[Account],
    ";"
    )
    )
     
     
    State(s) Measure =
    IF (
    ISFILTERED ( 'Table'[ID] ),
    CONCATENATEX (
    SUMMARIZE ( FILTER ( 'Table', 'Table'[Account] <> "John" ), 'Table'[State] ),
    'Table'[State],
    ";"
    )
    )
     
    Level(s) Measure =
    IF (
    ISFILTERED ( 'Table'[ID] ),
    CONCATENATEX (
    SUMMARIZE ( FILTER ( 'Table', 'Table'[Account] <> "John" ), 'Table'[Level] ),
    'Table'[Level],
    ";"
    )
    )
     
     
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

     
    • sc27's avatar
      sc27
      Frequent Visitor
      5 years ago

      I didn't think this would matter, but in my data, the ID is in one table (its a Fact table) and the Account, State and Level are all within one other. I tried to do what you sent over but it just concatenated every single Account, paying no mind to the relationship between the ID and the correct Accounts