REMOVEFILTERSREMOVEFILTERS

Filters wissen uit de gespecificeerde tabellen of kolommen.Clear filters from the specified tables or columns.

SyntaxisSyntax

REMOVEFILTERS([<table> | <column>[, <column>[, <column>[,…]]]])

ParametersParameters

TermTerm DefinitieDefinition
tabeltable De tabel waaruit u filters wilt wissen.The table that you want to clear filters on.
kolomcolumn De kolom waaruit u filters wilt wissen.The column that you want to clear filters on.

RetourwaardeReturn value

N.v.t.N/A. Zie de opmerkingen.See remarks.

OpmerkingenRemarks

  • REMOVEFILTERS kan alleen worden gebruikt om filters te wissen, niet om een tabel te retourneren.REMOVEFILTERS can only be used to clear filters but not to return a table.

  • Deze functie wordt niet ondersteund voor gebruik in de DirectQuery-modus wanneer deze wordt gebruikt in berekende kolommen of veiligheidsregels (RLS) op rijniveau.This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Voorbeeld 1Example 1

DAX-queryDAX 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 

RetourneertReturns

DimProductCategory[EnglishProductCategoryName]DimProductCategory[EnglishProductCategoryName] [IsGrandTotal][IsGrandTotal] [TotalSales][TotalSales] [%Sales][%Sales]
Rij1Row1 WaarTrue 29358677,220729358677.2207 11
FietsenBikes Niet waarFalse 28318144,650728318144.6507 0,9645579205705380.964557920570538
AccessoiresAccessories FalseFalse 700759,96700759.96 0,0238689214344410.023868921434441
KledingClothing FalseFalse 339772,61339772.61 0,01157315799502150.0115731579950215

Voorbeeld 2Example 2

DAX-queryDAX 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

RetourneertReturns

DimProductCategory [EnglishProductCategoryName]DimProductCategory [EnglishProductCategoryName] DimProductSubcategory [EnglishProductSubcategoryName]DimProductSubcategory [EnglishProductSubcategoryName] [TotalSales][TotalSales] [%Sales][%Sales]
AccessoiresAccessories FietsenrekkenBike Racks 3936039360 0,056167590.05616759
AccessoiresAccessories FietsstandaardsBike Stands 3959139591 0,056497230.05649723
AccessoiresAccessories Flessen en houdersBottles and Cages 56798,1956798.19 0,081052280.08105228
AccessoiresAccessories ReinigingsmiddelenCleaners 7218.67218.6 0,01030110.0103011
AccessoiresAccessories SpatbordenFenders 46619,5846619.58 0,066527170.06652717
AccessoiresAccessories HelmenHelmets 225335,6225335.6 0,32155890.3215589
AccessoiresAccessories DrinkrugzakkenHydration Packs 40307,6740307.67 0,057519940.05751994
AccessoiresAccessories Binnen- en buitenbandenTires and Tubes 245529,32245529.32 0,350375780.35037578
FietsenBikes MountainbikesMountain Bikes 9952759,5649952759.564 0,351462280.35146228
FietsenBikes RacefietsenRoad Bikes 14520584,0414520584.04 0,512766080.51276608
FietsenBikes ToerfietsenTouring Bikes 3844801,053844801.05 0,135771640.13577164
KledingClothing PetjesCaps 19688,119688.1 0,057944930.05794493
KledingClothing HandschoenenGloves 35020,735020.7 0,103070990.10307099
KledingClothing ShirtsJerseys 172950,68172950.68 0,50901890.5090189
KledingClothing Korte broekenShorts 71319,8171319.81 0,209904530.20990453
KledingClothing SokkenSocks 5106,325106.32 0,015028640.01502864
KledingClothing HemdenVests 3568735687 0,105032010.10503201