Forum Discussion

razieh12's avatar
razieh12
Frequent Visitor
3 years ago
Solved

ALL function is not working in drill down

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...
  • Alef_Ricardo_'s avatar
    Alef_Ricardo_
    3 years ago

    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_'s avatar
Alef_Ricardo_
Icon for Resolver II rankResolver II
3 years ago

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.