Wondering if anyone else has run across this problem, and hoping someone might have some advice.
At the moment we sum all invoice lines against account code to create a measure of total sales. We have sales people (one to each account) and this works fine, but we also have BDM’s on some accounts, and in some cases an account can have multiple BDM’s (e.g. one in NSW, one in WA). When I add the BDM table in as a new dimension and tie it to the account code, it causes the revenue measure to multiply by the number of BDM’s per account. Any ideas on how to avoid this, and just have the BDM as a dimension that could be selected by, but not measured by any more than account code is now ?
Let me know if I can clarify, but essentialy, I have many lines adding up to one account code revenue value, then many BDM’s to one account code , which is causing revenue measure to multiply.