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)

PowerBI123456's avatar
PowerBI123456
Post Partisan
5 years ago

@amitchandak hi - what do you mean? That last table is what I am trying to get to in Power BI. I am just trying to see at the account level, if has any of the code combinations from the second table and which ones. Thanks!

v-xuding-msft's avatar
v-xuding-msft
Community Support
5 years ago

Hi PowerBI123456 ,

 

Have you resolved it? If yes, please accept the helpful answer as solution. Others will benefit from this thread. Thanks! If you still need help, please feel free to ask us.