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,077,865
Messages
5,336,849
Members
399,106
Latest member
anoufal

Some videos you may like

This Week's Hot Topics

Top