Applying filter on ALL function

[ivanuska]

Dear all,

I am rebuilding the data model after the developer has left and I am trying to apply filter for the calculated table below:

Accounts = SUMMARIZE(
    ALL(CurrentSnapshots[CUSTOMER_ID],CurrentSnapshots[SnapshotType],CurrentSnapshots[INVOICE_NUMBER],CurrentSnapshots[REMAINING_AMT_USD]),
    CurrentSnapshots[SnapshotType],
    CurrentSnapshots[CUSTOMER_ID], 
    "Count",COUNT(CurrentSnapshots[INVOICE_NUMBER]),
    "NetAmount",SUM(CurrentSnapshots[REMAINING_AMT_USD]),
    "PastDueAmount",CALCULATE(SUM(CurrentSnapshots[REMAINING_AMT_USD]), CurrentSnapshots[DueDays]>0),
    "MaxStage",CALCULATE(MAX(CurrentSnapshots[NEXT_ACTION_STAGE]),CurrentSnapshots[DrivingEligible]=1),
    "Collector Name", DISTINCT(CurrentSnapshots[COLLECTOR_NAME])
        )

I need to apply filter on field CurrentSnapshots[SnapshotType] to show only value "Current". I have tried different ways to integrate the FILTER function into the expression however without any luck.

Could you please help me?

Thank you in advance!

[Anonymous]

Hi,

Have you tried using allexcept()? 
Here is somewhat of a similar issue: https://community.powerbi.com/t5/Desktop/DAX-formula-to-combine-quot-Filter-quot-and-quot-ALL-quot/m...

[ivanuska · Accepted solution]

I finally manage to find the solution:

Table - 
SUMMARIZE(
FILTER( ALL (Table), SnapshotType = "Current"),
rest of expression
)