Forum Discussion
swapping between relationships
Hi
I am working with two tables dimBranch and dimClient. A client belongs to a Branch and a salesperson. A salesperson belongs to a Branch.
As an example branch A and Branch B. A salesperson can belong to branch A but sell on behalf of branch B.
The client will belong to branch B but be under that salesperson sales number. I need to create a board where I can filter either by branch or salesperson. Depending on what I select the board should show the salesperson or the numbers for all clients in that branch. I need to be able to view the board from a salesperson perspective or a branch.
I've tried userelationship but you can't put measures as a filter is there another way to do this so they can both share the same branch filter.
5 Replies
Hi philseim
could you show a more visual example?
I am understanding that one Sales Person can belong either to Branch A or B or multiple branches, is it correct?
A client can belong to multiple branches and or sales persons?
Thanks for the fast reply
A salesperson can only really belong to one branch but they can sell on behalf of another branch.
Another way of looking at it is I want a list of all salesperson belongong to the branch but also a list of clients belonging to that branch.
Below is an excel mockup:
Client Code Branch Salesperson ABC Amsterdam Mr X XYZ Amsterdam Mr Y Salesperson Salesperson Branch Mr X Amsterdam Mr Y Frankfurt Figures Fees ABC 100 XYZ 120
I want to filter my board on Amsterdam and get a figure of 220. But I want to have the ability to see Mr X belongs to Amserdam as an additional filter and be able to filter on that to get the figure and then get the value of 100. So my filter on salesperson would use something like userelationship in DAXMy board looks like something below:
