Forum Discussion

JayTG123's avatar
JayTG123
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Replace Unique Text Values to Number 1

Hi all,   I am hoping someone can help with this. I have a list of unique text values (Linked Permit column) and just want to replace this with a 1 so it can become a SUM and as a total on a card v...
Need Help
  • aj1973's avatar
    aj1973
    4 years ago

    Hi JayTG123 

    In Power Query add an conditional column and use IF is equal Blank then return 0, else 1 

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

BTW, you don't need another column to calculate the sum of non-blank values.

 

An alternative would be to write a measure that counts the non-blank values.

CountNonblank = CALCULATE ( COUNT ( Table1[Linked Permit] ), Table1[Linked Permit] <> "" )