DAX how to remove filters from more than one table with ALL/ALLExept

[ed7]

I need in the Filter() remove filters from a number of tables, but ALL and ALLExcept can remove filters only from one. Any workarounds? 

____

Here is the problem I'm trying to solve: I need to find a first month when customer purchased for more than specific amount lets say 100$.

Formula: CALCULATE(FIRSTDATE('Calendar'[Month]), Filter(ALL('Calendar'),[Revenue]>100))

This formula works well but when I click slicer to filter to specific product on the report page, the calcualtion shows the first month when customer purchased that specific product for 100$+, but I don't want the slicer to impact this measure. 

[CNENFRNL · Accepted solution]

Hi, @ed7 ,

Indeed FILTER() accepts only one filterExpression, but all-mighty CALCULATE(), in theory, is capable of coping with as many as filters.

I hope this verbose measure may solve your issue which you mentioned

CALCULATE (
    FIRSTDATE ( 'Calendar'[Month] ),
    FILTER ( ALL ( 'Calendar' ), CALCULATE ( [Revenue], ALL ( product ) ) > 100 )
)

Better attach a dummy file so that your issue is demonstrated much more clearly and could possible be sooner to be solved by gurus here.

[wdx223_Daniel]

i think you can add a calculatetable out of the filter(), and remove any filter you want by adding filter statement