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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Cannot change and delete Measure when compare value to text

I will try to edit DAX in the last line but when I change this DAX

 

HelloTheSun_0-1708504445285.png

PowerBI popup the error follow on below.

Now I cannot change or delete this measure,
I think a cause of this problem because I fix the value in text "N/A",

 

please help

HelloTheSun_2-1708504562040.png

HelloTheSun_4-1708504634198.png

 

 

Status: Investigating

Hi @HelloTheSun ,

 

VALUES() is converting text type to number type and in your switch(), "" is used, which will lead to inconsistency, please try the same data type.

 

Best regards,
Community Support Team_ Scott Chang

Comments
v-tianyich-msft
Community Support
Status changed to: Investigating

Hi @HelloTheSun ,

 

VALUES() is converting text type to number type and in your switch(), "" is used, which will lead to inconsistency, please try the same data type.

 

Best regards,
Community Support Team_ Scott Chang