Forum Discussion

campelliann's avatar
campelliann
Post Patron
1 year ago
Solved

ALL strange behavior- Help please

Hi there,  So here I have a small table (unique table in the model for test purposes) where I want to ignore the filter context from column "Categoria"   Here I create the below measure (c...
Need Help
  • ibarrau's avatar
    ibarrau
    1 year ago

    Hi. Using ALL to a single column it's asking to remove filters for that specific column when used. However, if you are using another column to filter the same table, it will filter the table. That's why Categoria sem número will filter the count of categoria even if there is an ALL Categoria. You can add the column to the all (you can use more than one column to the all) or you can use the all for the whole table (it might perform slower with big data, really big)

    I hope that helps,

ibarrau's avatar
ibarrau
Super User
1 year ago

Hi. Using ALL to a single column it's asking to remove filters for that specific column when used. However, if you are using another column to filter the same table, it will filter the table. That's why Categoria sem número will filter the count of categoria even if there is an ALL Categoria. You can add the column to the all (you can use more than one column to the all) or you can use the all for the whole table (it might perform slower with big data, really big)

I hope that helps,