Forum Discussion
latheesh89
Helper II
Helper IIRemove context filter "except" for a given table (all columns)
Hi Techies, I am creating a measure something like below, = CALCULATE(SUM('Internet Sales[Sales Amount]), ALLEXCEPT('DimDate', 'DimDate'[Month Year],'DimDate'[Year]........) I wanted to s...
amitchandak
Super User
Super Userlatheesh89 , Allexcept will keep date filter. In case you want to remove date filter you can use removefilters or all
CALCULATE(SUM('Internet Sales[Sales Amount]), removefilters('DimDate'))
refer
https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
latheesh89Thanks amitchandak for your response.
No, I want to keep the DimDate filter and exclude other dimensions. As I mentioned my problem is I have many columns in DimDate that I will be using as slicer/filter in the report. So I'm finding a way to handle rather than adding alll the columns in ALLEXCEPT