DAX assistance

[Anonymous]

Hi everyone, having a mad morning, but I can't think of how to do this! I'm certain it's stupidly simple.

My table looks like this:

Name                Team

A.Nother           Sales

Toby Lerone      Repairs

Max Power        Calls

My users select a name using a slicer, and I'm looking for a measure (to display in a card and for further calculations) which gives the correct Team for the advisor selected.

I don't want to hard code names into the measure, so it can react to staff changes.

What simple thing am I missing? 🙂

Thanks

[Anonymous]

Thanks @BA_Pete 

Knew it was something simple, slicer wasn't single select so the MAX i had written wasn't working!

Thank you

[BA_Pete · Accepted solution]

Hi @Anonymous ,

If your report slicer is single-select i.e. the end user can only ever select one Advisor name at a time, then you can use:

_advisorTeam = MAX(table[Team])

Pete