How to make filter slice in measure

[Dwesty_A]

I want to make diagram venn, but the value is not a summary, but from list.

Example I have sport data in school.

Soocer Ball = Rudi, Budi, Agus, Tony, Andry, Rian, Chandra

Basket Ball = Yudhi, Chandra, Asep, Tony, Septian, Rony

Volly Ball = Chandra, Rony, Willy, Diandra, Robert, Youris

So the diagram being like this

But in my case name of slice still text in other chart.

How to make a measure not in measure, to get unique value? I make filter  not table[id] in [measure] but cannot get the uniq value. Please the advice, thank you.

[Anonymous]

Hi  @Dwesty_A ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

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

[Dwesty_A · Accepted solution]

Finally I got the answer, just write again the measure as variable