Forum Discussion

rocku2008_1985's avatar
rocku2008_1985
Icon for Helper I rankHelper I
3 years ago
Solved

Value Indicator creation for the measure

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, ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
rocku2008_1985
Icon for Helper I rankHelper I
3 years ago

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's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    3 years ago

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

    Nathaniel

    • Nathaniel_C's avatar
      Nathaniel_C
      Icon for Community Champion rankCommunity Champion
      3 years ago

      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