Power BI equivalent of referencing a cell in excel

[Anonymous]

I need some help with finding the Power BI equivalent of referencing a cell in excel. I have a table of about 200K rows and 7 columns and I am trying to dynamically create a new boolean column by comparing an values in an exsisting column with a changeable value in an input box.  For example, If I type 80% into the input box, I want to compare it with each value in column 7, and if greater than, return 1, or 0.....just like one would in excel by simply refernce the imput cell.

Thanks!

[tamerj1 · Accepted solution]

Hi @Anonymous 
This is how you do it in power bi (refer attached sample file)