Grouping an EXACT Match

Question

Hello,&nbsp;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 provider, lets say....who's number is 337, that provider will also show in this grouping because of a partial match to the "37". How can I change this formula so it only pulls exact matches?&nbsp;Supervising&nbsp;Provider&nbsp;Team&nbsp;=IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;SEARCH&nbsp;(&nbsp;"37",&nbsp;Transactions[Supervising&nbsp;Provider&nbsp;ID],,&nbsp;-1&nbsp;)&nbsp;&gt;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;SEARCH&nbsp;(&nbsp;"115",&nbsp;Transactions[Supervising&nbsp;Provider&nbsp;ID],,&nbsp;-1&nbsp;)&nbsp;&gt;&nbsp;-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;SEARCH&nbsp;(&nbsp;"74",&nbsp;Transactions[Supervising&nbsp;Provider&nbsp;ID],,&nbsp;-1&nbsp;)&nbsp;&gt;&nbsp;-1,&nbsp;&nbsp;&nbsp;&nbsp;"Team&nbsp;Byrd",&nbsp;&nbsp;&nbsp;&nbsp;"Error&nbsp;-&nbsp;Contact&nbsp;Tabatha")

datainsights · Accepted Answer

TabathaN,&nbsp;try this calculated column:&nbsp;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"
)&nbsp;

Forum Discussion

Grouping an EXACT Match

2 Replies

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Community User Group Experience

User Group Leader Get Started Guide

FAQ on the Fabric User Groups

Groups