Switch True

[gauravnarchal]

Hello - I want to create a measure to use it in the matrix as

If column b = blank return unassigned else return the value.

[VahidDM]

Hi @gauravnarchal 

Try this measure:

Measure = 
IF(MAX('Table'[B])=blank(),"unassigned",MAX('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!! 

LinkedIn | Twitter | Blog | YouTube 

[gauravnarchal]

Hi @VahidDM  When i use this measure, I am not able to add this to the rows instead it only taking it values.

[VahidDM · Accepted solution]

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!! 

LinkedIn | Twitter | Blog | YouTube