Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post Partisan
5 years ago
Solved

Searching for Combos

I am trying to identify if an account has specific code combination(s). I have 2 tables, one showing codes by account:      The second table showing different code combinations: I nee...
Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    @PowerBI123456 - I did it this way:

    Measure 5 = 
    VAR __Codes = SELECTCOLUMNS('Table (5)',"Code",[Code])
    VAR __Table = FILTER('Table (5a)',[Code 1] IN __Codes && [Code 2] IN __Codes)
RETURN
    CONCATENATEX(__Table,[Code 1] & "&" & [Code 2],", ")

    PBIX is attached below sig, Page 5, Table (5) and Table (5a)

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

@PowerBI123456 - I did it this way:

Measure 5 = 
    VAR __Codes = SELECTCOLUMNS('Table (5)',"Code",[Code])
    VAR __Table = FILTER('Table (5a)',[Code 1] IN __Codes && [Code 2] IN __Codes)
RETURN
    CONCATENATEX(__Table,[Code 1] & "&" & [Code 2],", ")

PBIX is attached below sig, Page 5, Table (5) and Table (5a)