Need help with how to calculate outstanding amount

[tobny76]

Hi all,
I will be very happy if someone can help me with the "Oustadning amount measure".
Don't get it to work and we have release soon.

We should calculate the outstanding amount based on the date selected in the dropdown.

Example data

I will attach the testfiles I have prepaired to getting started quickly.
We have release soon so I will be very happy if somone can help with this. 

Testdata in Excel 
PBIX test file 

Thanks in advance!

[v-sgandrathi]

Hi @tobny76

Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[sjoerdvn · Accepted solution]

Outstanding Amount Selected Date = 
CALCULATE(
    SUM(SALES_LEDGER_PAYMENTS_M3[Net Amount Local]),
    ALL(SALES_LEDGER_PAYMENTS_M3[Transaction Code]), 
    ALL('Calendar'),
   All(SALES_LEDGER_PAYMENTS_M3[Net Amount Local]),
    All(SALES_LEDGER_PAYMENTS_M3[Payment Date]),
    SALES_LEDGER_PAYMENTS_M3[Accounting Date] <= SELECTEDVALUE(CALENDAR_OVERDUE_SELECTION[Date])
)

[tobny76]

If I use your solution it looks like I need to add a new all statemant for every new column I add from the fact table into the visual, or?
Will this not be the same 

Outstanding Amount Selected Date =
CALCULATE(
    SUM(SALES_LEDGER_PAYMENTS_M3[Net Amount Local]),
    ALLEXCEPT(
      SALES_LEDGER_PAYMENTS_M3,
      SALES_LEDGER_PAYMENTS_M3[Invoice Number],
      SALES_LEDGER_PAYMENTS_M3[CompanyKey]
),
    SALES_LEDGER_PAYMENTS_M3[Accounting Date] <= SELECTEDVALUE(CALENDAR_OVERDUE_SELECTION[Date])
)

[sjoerdvn]

Well, technically your measure will work as well, but I would avoid ALL() and ALLEXCEPT() since it will also disable other slicers or filters you may add in the future.
Also, I added [Net Amount Local] and [Payment Date] to get your example working but I would never add these columns to that visual. Instead I would add measures like "Total Invoiced Amount" and "Last Payment Date".