topic Re: Filter multiple values in a column from filters selected in DAX Commands and Tips

Filter multiple values in a column from filters selected

Anonymous — Thu, 21 Mar 2024 11:32:16 GMT

I have 2 tables. Table A is a dimension table having 2 columns, code and description. There are 8-10 codes in this table along with their descriptions.

Code	Description
914940002	Some text1
914940004	Some text2

Table B is a fact table having multiple columns, one of which is code. Code column in Table B has rows with in the following format:

Code	Description
914940002	Some text1
914940002, 914940004	Some text1, Some text2

and so on. I want to filter Table B by Table A such that when I click a Description from Table A (I will be using Table A as a filter slicer), it returns all the rows in Table B that contain that Description (in the above example, both rows will return as they both contain that description).

Please explain using Power Query or DAX how I can do this

Re: Filter multiple values in a column from filters selected

Hazenm — Thu, 21 Mar 2024 12:45:50 GMT

Anonymous - Can you modify Table B? Or does it have to remain in that format?
If you can modify Table B, I would use power query to split the code column into rows. If you go into power query, and right click on the column table for code and click "Split Column" -> "By Delimiter" then select Comma. Then you can select advanced options, and split into new rows.
This will split your table and give each code line a unique row.
Then you can create a relationship between table A and table B on Code column, and your visualizations will filter as needed.

Re: Filter multiple values in a column from filters selected

JamesFR06 — Thu, 21 Mar 2024 13:20:49 GMT

@OsamaKamal

Mesure 8 =

Var texte=selectedvalue(Table1[Description])

var textfinal=SELECTEDVALUE('Table2'[Code])

return

if(CONTAINSSTRINGEXACT(textfinal,texte),1)

And after you put this measure in your panel filter with value 1 and only rows with the selected text will be in

Re: Filter multiple values in a column from filters selected

Anonymous — Thu, 21 Mar 2024 13:45:45 GMT

Table 1 and Table 2 are A and B respectively ? As per the tables I shared

Re: Filter multiple values in a column from filters selected

JamesFR06 — Thu, 21 Mar 2024 13:50:25 GMT

Yep sorry. Table1 is Table A and T2 Tb

Re: Filter multiple values in a column from filters selected

Anonymous — Thu, 21 Mar 2024 13:52:34 GMT

This doesn't work

Re: Filter multiple values in a column from filters selected

Anonymous — Thu, 21 Mar 2024 15:22:18 GMT

This works. Thank you!