Keep some filters using ALL funcition

Question

I have this measure to keep an value as constant according to a group, something like this:&nbsp;TOTAL = CALCULATE (&nbsp; &nbsp; [SALES],&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; ALL(PRODUCTS),&nbsp; &nbsp; &nbsp; &nbsp; PRODUCTS[CATEGORY] = SELECTEDVALUE(PRODUCTS[CATEGORY])))&nbsp;But i need to keep some filters, like [MONTH], [CITY] and [COLORS], how do i define these exceptions?&nbsp;Thanks,&nbsp;Lucas.

seanan · Accepted Answer

Hi&nbsp;salucas&nbsp;
&nbsp;
You can use an ALLEXCEPT function.&nbsp;ALLEXCEPT function (DAX) - DAX | Microsoft Learn

Forum Discussion

Keep some filters using ALL funcition

1 Reply

Related content

Filter data using slicer

Using measure as a filter

Dynamic filter using lookups

How to use FILTER() inside CALCULATE()

Using CONCATENATEX with FILTERS