Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all, I've spent quite a while staring at this, and finally decided "i need help" - much appreciated in your taking the time to understand and assist.
To start with my goal, I'm trying to get a method of linking product usage to a sales rep so they can get paid on the number of "txn_units_nbr", but there's some complex logic here that I'm not quite sure how to navigate in power bi. Ideally, I have a measure that is something like "attained txns" which can then be used to slice and dice in visuals with a given employee_id selected (the number would be meaningless without first having a single employee_id selected).
Also, as considering ideas, I have complete control over the data model, so if there is a better data model idea for this I'm open to that too.
My data model is as follows (not sure what relationships to make for RepMapping, so left disconnected for sample purposes):
The business logic for ascribing the txn_units_nbr to a given rep is as follows:
So i'd like to be able to do maths like:
Employee ID: 123456
Gets attained a total of X txn_units
Y of those txn_units comes from product index 16
Z of those txn_units comes from account A
You probably get the gist at this point... Here is a sample pbix with some data in it that could help: Sample PBIX File
Hi @Anonymous ,
If you want to add the table RepMapping to this mode, you must have the same column that can be matched with a table, so that you can create a relationship.
It’s not very clear that you end up with a description... Can you tell you what the final expected result will look like?
This is a related link, I hope to help you:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |