Forum Discussion
gauravnarchal
Post Prodigy
Post ProdigySwitch True
Hello - I want to create a measure to use it in the matrix as If column b = blank return unassigned else return the value.
You need to add a calculated column instead.
Use this and add a new column with DAX:
New Column= IF('Table'[B]=blank(),"unassigned",'Table'[B])If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
gauravnarchalPost Prodigy
Post ProdigyHi VahidDM When i use this measure, I am not able to add this to the rows instead it only taking it values.
VahidDM
Super User
Super UserYou need to add a calculated column instead.
Use this and add a new column with DAX:
New Column=
IF('Table'[B]=blank(),"unassigned",'Table'[B])
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!