Value Indicator creation for the measure

[rocku2008_1985]

I have a Column A in a table that has valid values and blank values. I want to create a value indicator measure in power BI. I am not sure how to do it as I am new to Power BI.

in sql we usally do,

case when column A  <> '' then Y

else N

So, How do we implement this in measuire in power BI? Could you please help me out? I am stuck here.

[Anonymous · Accepted solution]

Hi @rocku2008_1985 ,

Please try below steps:

1. below is my test table

Table:

2. create a new column with below dax formula

Column = IF([Column2]<>BLANK(),"Y","N")

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rocku2008_1985]

@Nathaniel_C : I did that but I am facing the issues as shown below. The value is blank but if I keeo it blank it gives the issue as shown:

Could you please help me out?

[Nathaniel_C]

Hi @rocku2008_1985 
In PQ what type of value is that column?

Nathaniel

[Nathaniel_C]

Hi @rocku2008_1985 ,
Make sure it is alpha.  Below is what I get.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Nathaniel_C]

Hi @rocku2008_1985 
Go to Power Query - Add a Column tab - Conditional Column:

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel