Calculate the exception measure as the sum of absolute adjustment-entry values where approval status is not approved

Finding and your answer

Calculate the exception measure as the sum of absolute adjustment-entry values where approval status is not approved

Partial match 95%

How the model read it

The model contains SignedAmount and IsAdjustment, while ApprovalStatus is supported upstream. No exact DAX was available and the requested measure was not observed. The component concepts partially map, but the calculation and treatment of status values remain unimplemented or unverified.

Workbook evidence

Consultant Requirement!A5

Cited current gold

fde-finance.current-model fde-finance.journal-controls

Open questions

Does 'sum the absolute value' mean SUMX over ABS(SignedAmount) per qualifying entry?

Does 'not approved' include blank, pending, rejected, cancelled, or unknown statuses?

Should reversals and duplicate adjustment entries be handled specially?

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why Decided by

Confirmed partial and gap answers enter the scope queue. “Needs more evidence” enters the research queue and blocks the scope document until it is resolved.