Forum Discussion
Solved
Applying filter on ALL function
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!
I finally manage to find the solution:
Table - SUMMARIZE( FILTER( ALL (Table), SnapshotType = "Current"), rest of expression )
2 Replies
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-p/558754#M263432I finally manage to find the solution:
Table - SUMMARIZE( FILTER( ALL (Table), SnapshotType = "Current"), rest of expression )
