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_...
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-p/558754#M263432
I finally manage to find the solution:
Table -
SUMMARIZE(
FILTER( ALL (Table), SnapshotType = "Current"),
rest of expression
)