Forum Discussion

michaelccdf's avatar
michaelccdf
Helper I
6 years ago
Solved

Remove a single filter from a table

I'm trying to remove just one filter (from the filter pane) from a table below.  There are other filters from slicers that I would like to keep, thus I can't use ALL.  I suppose I could use ALLEXCEPT...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi, 

     

    if you use calculate with all(columnname) then you release the filter on the column. (Only CALCULATE and CALCULATETABLE change the filter context)

     

    so it would be something like:
    calculate( "your calculation" like max(A) or sum(B),

    All(columnname)
    )

     

    https://docs.microsoft.com/en-us/dax/calculate-function-dax

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, 

 

if you use calculate with all(columnname) then you release the filter on the column. (Only CALCULATE and CALCULATETABLE change the filter context)

 

so it would be something like:
calculate( "your calculation" like max(A) or sum(B),

All(columnname)
)

 

https://docs.microsoft.com/en-us/dax/calculate-function-dax