नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
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.