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!!
3 Replies
gauravnarchalHi 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
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!!