ALL strange behavior- Help please

[campelliann]

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 (countall) /visual. And the behavior is as expected. PowerBI ignores the filter from "category" column, and counts 4 people. 

But why when I add a filter that is less restritive on a new column "Categoria sem número". ALL does not work, and counts only 2 trainees.

Even weirder for me is this, the difference of results for first row on 1.Trainee between the previous and below example. Why does countall measure here give me 3 on trainee? On the matrix I have a filter on trainee on the first row. But in the previous image, when I apply the slicer on trainee, the result is 2. Shouldnt the result be the same? Both in the matrix, and in the slicer I am applying the following filter [Categoria]="1. Trainee"

[ibarrau · Accepted solution]

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,

[campelliann]

Hi there. Thank you very much. Here is the deeper explanation - Auto exist
 https://www.sqlbi.com/articles/understanding-dax-auto-exist/

[campelliann]

@ibarrau , could you help here mate? Many thanks 🙂