Creating a trial balance

[DWig]

Hey all, I'm back with another one. I'm trying to create a trial balance measure in DAX.

=if(isblank(sum(GLSummary[Debit])-sum(GLSummary[Credit])),0,sum(GLSummary[Debit])-sum(GLSummary[Credit]))

I get the error message "Could not add the field "MeasureX" to the PivotTable because the formula is invalid."

I'm pretty confused at this point. Any insight would be greatly appreciated.

 

[Jacob Barnett]

Hi, fundamentally your measure looks fine, I suspect you are experiencing is a PowerPivot idiosyncracy.

There are circumstances where I see this error, usually if I am creating a measure in an already complex report - a save/close/reopen usually does the trick however there are times when the measure I have created has 'disappeared'.

If you just want the zero for presentational purposes I would be tempted to use the Pivot table option to display zero instead of blanks:

Jacob

 

[DWig]

Thank you, Jacob. That worked! Thanks for your help.