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.
