Use pipe separated values as filter

[Anonymous]

Hi,

I Need filter a table column based on cell with pipe separated values, thanks.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

First go to query editor>split column filter(table B):

Then create a measure as below:

Total = SUMX(FILTER(ALL('Table A'),'Table A'[ID]=MAX('Table B'[Filter.1])),'Table A'[Value])+SUMX(FILTER(ALL('Table A'),'Table A'[ID]=MAX('Table B'[Filter.2])),'Table A'[Value])

And you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[DataInsights]

For the "Table B" query, split the Filter column into rows as shown below: