REMOVEFILTERS not working

[gspollock]

Hi All,

I have a measure that is not removing the row context using REMOVEFILTERS.  I have tried two different versions of the measure:

Number Accounts Shared Quarterly = CALCULATE(DISTINCTCOUNT(V_MBA_MMS_REPORT_SHARE[account_id]),REMOVEFILTERS(V_MBA_MMS_REPORT_SHARE[account_id]))

Number Accounts Shared Quarterly = CALCULATE(CALCULATE(DISTINCTCOUNT(V_MBA_MMS_REPORT_SHARE[account_id])),REMOVEFILTERS(V_MBA_MMS_REPORT_SHARE[account_id]))

For example these are three account managers and their correct counts:

OWNER_EID	Number Accounts Shared Quarterly
esjwixi	2
e1fcaji	4
e0kadzh	5

When I add the ACCOUNT_ID column it has the number of accounts equal to 1.  It is not ignoring the row context.

OWNER_EID	ACCOUNT_ID	Number Accounts Shared Quarterly
esjwixi	3809342	1
esjwixi	54872002	1
e1fcaji	203322	1
e1fcaji	4410094	1
e1fcaji	4531882	1
e1fcaji	54517460	1
e0kadzh	347394	1
e0kadzh	1268276	1
e0kadzh	3922424	1
e0kadzh	4059103	1
e0kadzh	54406994	1

Does the fact that the it is counting a column rather than aggregating a measure cause the problem?  If so what is an alternative method?

Thanks for your help.

[ppm1 · Accepted solution]

Your first measure works fine in a table visual. Do you happen to have a sort-by columns set up?

Pat

[gspollock]

It was sorting on the measure.  I didn't set it to that.  It is now working.