Create caclulated table in power pivot

I found out why it did not allow to Import as table, but it still does not work. 🤷‍♀️

Following your guide:

1. Create table with >1 columns (1 column just did not work!)
   
2. Importing a table supporting DAX actually worked without explicitly adding the dummy table to power pivot data model:
   Existing Connections > (This Workbook) > Select the dummy table
   

   Then it can be imported as a Table

   
3. Then you can right-click on the newly created table and edit DAX
   
4. But now I need to use DAX function VALUES, and it does not work
   
   The error is: Syntax for 'VALUES' is incorrect.
   

   

I'm pretty sure the DAX is correct, because column BusinessCatalogs[Business Role ID] does exist.