parameter & caculated column

by creating parameters and using invoke function in BI

you can realize the following result:

if you change the contents of an excel table on your desktop. for instance the ID code, you can meanwhile get a table in BI 

which automaticly shows ID code and other relavant columns(ususally from another table) , just like vlookup.

but the question is the caculated columns can not be invoked.

how to solve this problem?

waiting for your advice

thank you inadvance

joey