Forum Discussion
Solved
Switch 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!!
Hi VahidDM When i use this measure, I am not able to add this to the rows instead it only taking it values.
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!!
