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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!