Forum Discussion
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 Le...
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
BA_Pete
Super User
Super UserHi 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