Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
I finally manage to find the solution:
Table -
SUMMARIZE(
FILTER( ALL (Table), SnapshotType = "Current"),
rest of expression
)
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...
I finally manage to find the solution:
Table -
SUMMARIZE(
FILTER( ALL (Table), SnapshotType = "Current"),
rest of expression
)
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |