cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Change slicer values

Hello all,

 

I'm trying to change the values of column operatorGroupId and put these changed values into a new column. 

 

So far I've tried the following: 

test = IF(Incidents[operatorGroupId], "580d91e7-6252-4b98-a0ca-06e6533f4b21","Audioproductie Rijswijk") - gives error that it cannot convert ''580d etc'' from a text based to a true/false. 
 
test = IF(Incidents[operatorGroupId]=FALSE(), "580d91e7-6252-4b98-a0ca-06e6533f4b21","Audioproductie Rijswijk") - Error that DAX does not support comparing values of type text with values of type true/false
 
Any ideas how this is done otherwise?
 
Part of the reason why I'm doing this is because the table for operatorGroupId (OperatorGroups) doesn't want to active a many to one relationship because another look up table (IncidentTypes) already has a similar relation with the Incidents table. I'm confused as to why it refuses because both IncidentTypes & OperatorGroups are look up tables. The above problem can be solved by this one, but I am happy for either solution. 
bendedicon_0-1621413785771.png

 

1 ACCEPTED SOLUTION
PaulDBrown
Super User
Super User

Try:

test = IF(Incidents[operatorGroupId] = "580d91e7-6252-4b98-a0ca-06e6533f4b21","Audioproductie Rijswijk")





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

1 REPLY 1
PaulDBrown
Super User
Super User

Try:

test = IF(Incidents[operatorGroupId] = "580d91e7-6252-4b98-a0ca-06e6533f4b21","Audioproductie Rijswijk")





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.