Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX assistance

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

Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
    BA_Pete
    Icon for Super User rankSuper User
    5 years ago

    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