Slicer with only one value inputs full column

Hi Anonymous ,

Do you want to create a slicer with only value with full data from areacoaches column? We need to combine all data from areacoaches column to one by creating a new table. We couldn't add a measure into slicer.

 What does "by network" mean? 

I build a sample to have a test.

Build a calculated table by this code:

Table 2 = SUMMARIZE('Table',"Full data", CONCATENATEX('Table','Table'[areacoaches]," "))

Result is as below.

Best Regards,
Rico Zhou

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