Forum Discussion
Use pipe separated values as filter
Hi,
I Need filter a table column based on cell with pipe separated values, thanks.
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,
KellyDid I answer your question? Mark my post as a solution!
2 Replies
For the "Table B" query, split the Filter column into rows as shown below:
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,
KellyDid I answer your question? Mark my post as a solution!
