Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

accounting math question

So I have a database that just keeps all transaction amounts in one column, regardless of charge or refund.  There is a seperate column that tracks if refund (true/flase) I need to calculate the net...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    There is limitation in DAX when you direct query because of performance.

     

    Goto option and Settings -> Options -> Direct Query and check "Allow unrestricated measures in Direct Query mode" and see if this works for you. 

     

    There are lot of articles what are the restriction in direct query mode, please check those out.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I keep getting these stupid mesages

Column = RELATED(vwAppraisalComposite[TotalFee])-(AppraisalAccountingItem[Net Total])

Function 'CALCULATE' is not allowed as part of calculated column DAX expressions on DirectQuery models.

parry2k's avatar
parry2k
Super User
8 years ago

There is limitation in DAX when you direct query because of performance.

 

Goto option and Settings -> Options -> Direct Query and check "Allow unrestricated measures in Direct Query mode" and see if this works for you. 

 

There are lot of articles what are the restriction in direct query mode, please check those out.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    FYI, I had already set this option up and it did not work.  I had to turn it off and then back on 2 more times in order to get it to work.