Created columns with DAX on columns imported with Direct Query not working

[TIMTIM]

Hello Folks 

I'm working on a project to ameliorate my skills using power BI

i created 3 tables on Oracle DB (data_2018, market segment and meals) i imported the data on power BI with direct query using this statement : 

select A.*,b.cost,c.discount,(STAYS_IN_WEEKEND_NIGHTS + STAYS_IN_WEEK_NIGHTS) as nbr from DATA_2018 A left join meal B on A.meal = B.meal left join client_segment C on A.market_segment = C.market_segment 

Then i created this column in DAX :  

Coln = Query1[NBR] * Query1[ADR] 

and this one : 

total = (Query1[CHILDREN] + Query1[ADULTS])* Query1[COST] + Query1[Coln] 

however, when i try to display the total on a card or use any other visual 

i get this message : 

Error Message:
ORA-00904: "c36": invalid identifier. The exception was raised by the IDbCommand interface. 

My Question is : how to solve this issue and if there and particular tips with DAX when we work using Direct Query

Thanks in advance

[lbendlin]

 i imported the data on power BI with direct query

No.  It's either Import Mode or Direct Query. But not both.

The error happens on the Oracle side. Check your views/queries there.