Check column if blank or null

[Anonymous]

Hello, currently working on a project and i encounter some difficulties. 

Im trying to check the column using measures if the column KPI has "Blank", "Yes" or "No" entries on that column. The condition would be if KPI column is "blank", the result would be "blank". If KPI column is "No", then the result would be "5" and if KPI column is "Yes" the result should "0". Im done with the Yes and No condition but when im adding the blank part i cant get it right because "Isblank" is only used for measure and i cant put the column name their. Is there any possible way to resolve this? Thanks in advance.!

[FreemanZ · Accepted solution]

hi @Anonymous 

try to add a calculated column like:

Column =

SWITCH(

    [KPI],

   "Yes", 0,

    "No", 5,

    BLANK()

)