Filter Project Names

[Anonymous]

Hello Power BI Community, I want to filter the project names List by "Region: Europe" for example, what would be the correct way to do this?

Region: Europe filters all the other regions out so I would only have a list of european projects

I tried to use 

Project Names new = Calculate(All([..]Projectnames), Filter ([...],[...]Region: Europe)) 

But I didn't get the results I was looking for

[amitchandak]

@Anonymous , You create a measure and use that with the project name in Visual

countrows(filter(table, Table[region]= "Europe" ))

[Anonymous]

I have a list with different %values. How do I "connect" the new measure with the project names?

[v-yueyunzh-msft]

Hi , @Anonymous 

Do you mean the "Region: Europe" is a list? If this you can use "IN" logic operator to get teh data you need.

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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