Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
sraj
Responsive Resident
Responsive Resident

Manage rules DAX fun for INT

Hi,

I am using this in Manage roles to segregate by different queues and I thought this would work [NODE_ID] = "1363", but I am getting this error message.  Data type for NODE ID is whole number.  Can somone please help?

 

sraj_0-1674829793889.png

 

1 ACCEPTED SOLUTION

Hi @sraj 

 

It should be [NODE_ID] = 1363 rather than [NODE_ID] = "1363". Adding double quotes around a number will conver it into Text type. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

4 REPLIES 4
sraj
Responsive Resident
Responsive Resident

May be I am not understanding this but the value is INT 1363  which is a number, can you please specify?  Are you saying it has to be text and not number?

Hi @sraj 

 

It should be [NODE_ID] = 1363 rather than [NODE_ID] = "1363". Adding double quotes around a number will conver it into Text type. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

sraj
Responsive Resident
Responsive Resident

Thank you @v-jingzhang 

HotChilli
Super User
Super User

"1363" is a text string.  It needs a number

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors