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

simonbourdeau's avatar
simonbourdeau
Regular Visitor
8 years ago

This is not a solution. It does not solve the problem.