ALL not working as expected

DickyMoo

New Member
Joined
Mar 8, 2016
Messages
32
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

New Member
Joined
Mar 8, 2016
Messages
32
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
 

Forum statistics

Threads
1,078,253
Messages
5,339,105
Members
399,278
Latest member
randomNumberGenerator2211

Some videos you may like

This Week's Hot Topics

Top