Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security
updates, and technical support.

[ Download Microsoft Edge ](https://go.microsoft.com/fwlink/p/?LinkID=2092881
) [ More info about Internet Explorer and Microsoft Edge
](https://learn.microsoft.com/en-us/lifecycle/faq/internet-explorer-microsoft-
edge)

Table of contents  Exit focus mode

Read in English  Save  [ ](https://github.com/MicrosoftDocs/query-
docs/blob/main/query-languages/dax/allcrossfiltered-function-dax.md "Edit This
Document")

Table of contents  Read in English  Save  Add to Plan  [ Edit
](https://github.com/MicrosoftDocs/query-docs/blob/main/query-
languages/dax/allcrossfiltered-function-dax.md "Edit This Document") Print

Twitter  LinkedIn  Facebook  Email

Table of contents

#  ALLCROSSFILTERED

  * Article 
  * 10/20/2023 
  * 2 contributors 

Feedback

##  In this article

Clear all filters which are applied to a table.

##  Syntax

    
    
    ALLCROSSFILTERED(<table>)
    

###  Parameters

Term  |  Definition   
---|---  
table  |  The table that you want to clear filters on.   
  
##  Return value

N/A. See remarks.

##  Remarks

  * ALLCROSSFILTERED can only be used to clear filters but not to return a table. 

  * This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. 

##  Example

    
    
    DEFINE
    MEASURE FactInternetSales[TotalQuantity1] =
        CALCULATE(SUM(FactInternetSales[OrderQuantity]), ALLCROSSFILTERED(FactInternetSales))
    MEASURE FactInternetSales[TotalQuantity2] =
        CALCULATE(SUM(FactInternetSales[OrderQuantity]), ALL(FactInternetSales))
    EVALUATE
        SUMMARIZECOLUMNS(DimSalesReason[SalesReasonName], 
            "TotalQuantity1", [TotalQuantity1],
            "TotalQuantity2", [TotalQuantity2])
        ORDER BY DimSalesReason[SalesReasonName]
    
    

Returns,

DimSalesReason[SalesReasonName]  |  [TotalQuantity1]  |  [TotalQuantity2]   
---|---|---  
Demo Event  |  60398  |   
Magazine Advertisement  |  60398  |   
Manufacturer  |  60398  |  1818   
On Promotion  |  60398  |  7390   
Other  |  60398  |  3653   
Price  |  60398  |  47733   
Quality  |  60398  |  1551   
Review  |  60398  |  1640   
Sponsorship  |  60398  |   
Television Advertisement  |  60398  |  730   
|  |   
  
Note

There is a direct or indirect many-to-many relationship between
FactInternetSales table and DimSalesReason table.

* * *

##  Feedback

Was this page helpful?

Yes  No

##  Feedback

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the
feedback mechanism for content and replacing it with a new feedback system.
For more information see: [ https://aka.ms/ContentUserFeedback
](https://aka.ms/ContentUserFeedback) .

Submit and view feedback for

This page

[ View all page feedback  ](https://github.com//issues)

* * *

##  Additional resources

[ California Consumer Privacy Act (CCPA) Opt-Out Icon  Your Privacy Choices
](https://aka.ms/yourcaliforniaprivacychoices)

Theme

  * Light 
  * Dark 
  * High contrast 

  *   * [ Previous Versions ](/en-us/previous-versions/)
  * [ Blog ](https://techcommunity.microsoft.com/t5/microsoft-learn-blog/bg-p/MicrosoftLearnBlog)
  * [ Contribute ](/en-us/contribute/)
  * [ Privacy ](https://go.microsoft.com/fwlink/?LinkId=521839)
  * [ Terms of Use ](/en-us/legal/termsofuse)
  * [ Trademarks ](https://www.microsoft.com/legal/intellectualproperty/Trademarks/)
  * © Microsoft 2024 

##  Additional resources

###  In this article

[ California Consumer Privacy Act (CCPA) Opt-Out Icon  Your Privacy Choices
](https://aka.ms/yourcaliforniaprivacychoices)

Theme

  * Light 
  * Dark 
  * High contrast 

  *   * [ Previous Versions ](/en-us/previous-versions/)
  * [ Blog ](https://techcommunity.microsoft.com/t5/microsoft-learn-blog/bg-p/MicrosoftLearnBlog)
  * [ Contribute ](/en-us/contribute/)
  * [ Privacy ](https://go.micr