Forum Discussion
accounting math question
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.
Super UserTry something like this
Balance due =
CALCULATE ( SUM ( Table[Amoumt] ), MAX ( Table[Refund] ) <> TRUE () )
- CALCULATE ( SUM ( Table[Amoumt] ), MAX ( Table[Refund] ) = TRUE ())
Assiming your table is a true false field.
Not on computer but should work.
Regaeds,
Mfelix
I have gotten the math to work finally, problem is I have data in two different tables to use in the equation. Im getting an error when I try and use the total fee which is in table A, and need to subtract total charged which is in table B. Says I cant do this in direct querry
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
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.