Team Name does not exist

[ArchStanton]

Hi

At present Team XYZ does not exist as its own seperate entity within the system, this team will be created in the coming months.

I can however filter on the 20 employee names that will make up XYZ as a temporary solution.

Can I create a measure where I can use these 20 names as a sort of a filter in my visuals? 
Is this even possible?

I know I can manually filter these names and perhaps that is the only way?

Grateful for any help / advice on this.

[Slim- · Accepted solution]

Hi @ArchStanton 

There are many ways to do it, however they can be pretty tedious if there are no data in common that differentiate these employees from other.

For example you could create a new column in DAX with a IF(name = A || name = B || name = C || ..., Team XYZ, BLANK())

Not sure if I'm clear enough,

Regards,

[ArchStanton]

Thank you and apologies for the late reply, I knew about this calculated column option but tried to avoid it - don't think I have much choice.