REMOVEFILTERS
Applies to: Calculated column Calculated table Measure Visual calculation
Clear filters from the specified tables or columns.
Syntax
REMOVEFILTERS([<table> | <column>[, <column>[, <column>[,…]]]])
Parameters
Term | Definition |
---|---|
table | The table that you want to clear filters on. |
column | The column that you want to clear filters on. |
Return value
N/A. See remarks.
Remarks
REMOVEFILTERS 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 1
DAX query
DEFINE
MEASURE FactInternetSales[TotalSales] = SUM(FactInternetSales[SalesAmount])
MEASURE FactInternetSales[%Sales] = DIVIDE([TotalSales], CALCULATE([TotalSales],REMOVEFILTERS()))
EVALUATE
SUMMARIZECOLUMNS(
ROLLUPADDISSUBTOTAL(DimProductCategory[EnglishProductCategoryName], "IsGrandTotal"),
"TotalSales", [TotalSales],
"%Sales", [%Sales]
)
ORDER BY
[IsGrandTotal] DESC, [TotalSales] DESC
Returns
DimProductCategory[EnglishProductCategoryName] | [IsGrandTotal] | [TotalSales] | [%Sales] |
---|---|---|---|
Row1 | True | 29358677.2207 | 1 |
Bikes | False | 28318144.6507 | 0.964557920570538 |
Accessories | False | 700759.96 | 0.023868921434441 |
Clothing | False | 339772.61 | 0.0115731579950215 |
Example 2
DAX query
DEFINE
MEASURE FactInternetSales[TotalSales] = SUM(FactInternetSales[SalesAmount])
MEASURE FactInternetSales[%Sales] = DIVIDE([TotalSales], CALCULATE([TotalSales],REMOVEFILTERS(DimProductSubcategory[EnglishProductSubcategoryName])))
EVALUATE
SUMMARIZECOLUMNS(
DimProductCategory[EnglishProductCategoryName],
DimProductSubcategory[EnglishProductSubcategoryName],
"TotalSales", [TotalSales],
"%Sales", [%Sales]
)
ORDER BY
DimProductCategory[EnglishProductCategoryName] ASC,
DimProductSubcategory[EnglishProductSubcategoryName] ASC
Returns
DimProductCategory [EnglishProductCategoryName] | DimProductSubcategory [EnglishProductSubcategoryName] | [TotalSales] | [%Sales] |
---|---|---|---|
Accessories | Bike Racks | 39360 | 0.05616759 |
Accessories | Bike Stands | 39591 | 0.05649723 |
Accessories | Bottles and Cages | 56798.19 | 0.08105228 |
Accessories | Cleaners | 7218.6 | 0.0103011 |
Accessories | Fenders | 46619.58 | 0.06652717 |
Accessories | Helmets | 225335.6 | 0.3215589 |
Accessories | Hydration Packs | 40307.67 | 0.05751994 |
Accessories | Tires and Tubes | 245529.32 | 0.35037578 |
Bikes | Mountain Bikes | 9952759.564 | 0.35146228 |
Bikes | Road Bikes | 14520584.04 | 0.51276608 |
Bikes | Touring Bikes | 3844801.05 | 0.13577164 |
Clothing | Caps | 19688.1 | 0.05794493 |
Clothing | Gloves | 35020.7 | 0.10307099 |
Clothing | Jerseys | 172950.68 | 0.5090189 |
Clothing | Shorts | 71319.81 | 0.20990453 |
Clothing | Socks | 5106.32 | 0.01502864 |
Clothing | Vests | 35687 | 0.10503201 |
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru