ALL function is not working in drill down

[razieh12]

Hello , 

I want to visulaize data in matrix.

the rows of matrix are respectely: Provice, City.

the column is months which are 2 months

the value of the matrix is the below measure:

   CALCULATE(sum('sale'[quantity]),ALL('sale'[months]))

Problem: the measure works correctly in first layer which is province but when I dill down in the second layer it does not work correctely. for example for city 27 it must show 38 for two months but the value it shows is different.

ps: I tried isinscope as well , but the result is the same 

[Alef_Ricardo_ · Accepted solution]

Another possible solution could be to use the ALLEXCEPT function instead of the ALL function. The ALLEXCEPT function removes all filters from a table except for filters on specified columns. You can try using this function to remove all filters from your sale table except for filters on the Province and City columns.

Here’s an example of how you could use the ALLEXCEPT function in your measure:

CALCULATE(
SUM('sale'[quantity]),
ALLEXCEPT('sale', 'sale'[Province], 'sale'[City])
)

I hope this helps! Let me know if you have any further questions. 😊

[Alef_Ricardo_]

Hi razieh12,

It seems that you are trying to use the ALL function to remove the filter context from the months column in your sale table. However, when you drill down to the second level of your matrix, the ALL function is not working as expected.

One possible reason for this issue could be that there are other filters or slicers affecting the data in your matrix. You may want to check if there are any other filters or slicers applied to your data that could be affecting the results of your measure.