Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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?
Solved! Go to Solution.
@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"
)
Proud to be a Super User!
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!
@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"
)
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |