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 simplif...
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

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

      Hi, sc27 

      Please share your sample pbix file's link here.

      • sc27's avatar
        sc27
        Frequent Visitor
        5 years ago

        Unfortunately, you won't be able to see it. Access is maintained by an AD group and the data is sourced from a database which is also internal