Search code examples
powerbipowerquerypowerbi-desktoppower-bi-report-serverpowerbi-custom-visuals

Creating value indicator measure in Power BI

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 usually do,

case when column A <> '' then Y

else N

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

Solution

  • Add a calculated column with

    Indicator = IF( ‘Table‘[Column A] <> ‘‘, “Y“, “N“ )