Forum Discussion

TabathaN's avatar
TabathaN
Advocate III
5 years ago
Solved

Grouping an EXACT Match

Hello,   I have a formula, below, that groups data based on provider ID. The actual formula is quite long and contains multiple groupings like this. The issue I'm having is that if there is another...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    TabathaN, try this calculated column:

     

    Supervising Provider Team = 
SWITCH (
    TRUE (),
    Transactions[Supervising Provider ID] IN { 37, 115, 74 }, "Team Byrd",
    Transactions[Supervising Provider ID] IN { 38, 116, 75 }, "Team X",
    "Error - Contact Tabatha"
)

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  TabathaN ,

 

If you need to pull exact matches,use below dax expression:

Supervising Provider Team = 
SWITCH (
    TRUE (),
    Transactions[Supervising Provider ID] IN { 37, 115, 74 }, "Team Byrd",
    "Error - Contact Tabatha"
)

 I made a sample,see below:

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!