ALL not working as expected

[DickyMoo]

Hi All,

I am having trouble with removing a filter context with ALL. Formulas below:

Member Count = COUNT('MEMBERSHIP'[Member Number])
test = CALCULATE([Member Count], ALL(Dim_MemberCategory[Headline Category]) )

The tables are related by another column, [Fee Category] in both tables.

The figures are coming out the same, I'm going a bit mad. What am I doing wrong. I can upload the pbix if needed.

Any help appreciated.

Thanks
Richard

 

[DickyMoo]

Stand down everyone!

It turns out I had sorted Dim_MemberCategory[Headline Category] by another column so had to include that in the ALL.

Bloody DAX