Countif Equivalent in table (I cant figure out why the first image fails)

[campelliann]

Hi,

I would like to understand, why I do get 1 in every row (when trying to count the IDS of first column) with the first image. But then with the 2n image it works perfectly fine. Thanks!

1)

2)

[AlB · Accepted solution]

Hi @campelliann 

The short answer is: context transition, triggered by CALCULATE

A very important mechanism in DAX

You can override it with an ALLEXCEPT(Table1, Table1[equipa2])

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers