DAX query in direct mode

[ramkula123]

Hi All,

The below query doesnt work in direct query mode  for Calculate and All except:

Column = Table[ColD] - Calculate(MIN(Table[ColD]), ALLEXCEPT(Table, Table[ColA],Table[ColB],Table[ColC))+1

Can anyone help with alternatives ?

Thank you

[v-diye-msft · Accepted solution]

Hi @ramkula123 

Calculate is not work in a calculated column in direct query. please change it to measure using below formula:

Measure = var a = CALCULATE(MIN(Table[ColD]),ALLEXCEPT(Table,Table[ColA],Table[ColB],Table[ColC]))
Return
MAX(Table[ColD])-a+1

[v-diye-msft · Accepted solution]

Hi @ramkula123 

Calculate is not work in a calculated column in direct query. please change it to measure using below formula:

Measure = var a = CALCULATE(MIN(Table[ColD]),ALLEXCEPT(Table,Table[ColA],Table[ColB],Table[ColC]))
Return
MAX(Table[ColD])-a+1

[ramkula123]

Hi @v-diye-msft ,

Thank you for reply. This caculation needs to be as axis in one of the visuals , but since its a measure I am not able to do so .

Is there any possible workaround for this ?

Regards 

---

@v-diye-msft wrote:

Hi @ramkula123 

Calculate is not work in a calculated column in direct query. please change it to measure using below formula:

Measure = var a = CALCULATE(MIN(Table[ColD]),ALLEXCEPT(Table,Table[ColA],Table[ColB],Table[ColC]))
Return
MAX(Table[ColD])-a+1

---

[v-diye-msft · Accepted solution]

Hi @ramkula123 

I tried all methods as far as my knowledge, but still yet to access this because of the limitations on DAX and M code under DQ mode. I think you may change it to import mode for more performance.