Filtering a chart by another table containing parts of a word in a column.

[Marcin86]

Hi, 

I have problem with filtering chart by table contain unifid value.

Example data:

I am looking for a way to use table 2 to filter the chart (based on table 1).
The chart shows the sum of the Number column for a given month.

I can do to filter the tables but I have a problem with the chart.

Thanks

sorry for my english 🙂

[Marcin86]

It's almost good, but how to handle all the selected ones?

[v-yangliu-msft]

Hi  @Marcin86 ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _select=SELECTCOLUMNS('Table2',"1",[Region])
return
IF(
CONTAINSSTRING(
MAX('Table'[regionCode]),_select)=TRUE(),1,0)

Value =
    SUMX(
    FILTER(ALLSELECTED('Table'),  YEAR('Table'[Date])=YEAR(MAX('Table'[Date]))&&MONTH('Table'[Date])=MONTH(MAX('Table'[Date]))),[Number])

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly