Forum Discussion

sachin_kalra's avatar
sachin_kalra
New Member
9 years ago
Solved

Filter is not working in Direct query mode

HI Forum i am using direct query with sql and trying to calculate a value using TotalBudget = CALCULATE([SumBudget],FILTER(Fact_CE_AM_Revenue,Fact_CE_AM_Revenue[year]=MAX(Fact_CE_AM_Revenue[year]))...
Reports
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    sachin_kalra

     

    Please enable following option and have a try again.

     

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

sachin_kalra

 

Please enable following option and have a try again.

 

 

Best Regards,

Herbert

ptalanki's avatar
ptalanki
New Member
8 years ago

Enabling below option did not work. Below is our DAX query - 

MTD_Avg_Balance_Debt = TOTALMTD([Sumprin Debt],v_get_TransDate[TransDate])/(DATEDIFF(STARTOFMONTH(v_get_TransDate[TransDate]),max(v_get_TransDate[TransDate]),DAY)+1)

 

Works on desktop version, howver doesnt work once published to sever 

 

Power BI

MdxScript(Model) (23, 54) Function 'DATESMTD' is not supported in DirectQuery mode.
Please try again later or contact support. If you contact support, please provide these details.
Request ID0d017378-356c-923e-4938-8a86f54d5201
TimeFri Mar 16 2018 14:44:39 GMT+0530 (India Standard Time)
Version14.0.600.434