Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all! We have an issue in our PoweerBI environment that I could use some help with.
We have Accounts setup that Salespeople split the sales for sometimes up to a four person split. I need help splitting those sales for these split accounts into there respective Salesperson.
Below is how the Database is currently laid out. We have a transaction level link in factsales utilizing the Group Key to the DimDales Group. The dimsalesgroup contains unique individual salepserson names (no Splits), the next link in using the GRPkey and bridgesalesgroup contain the Split percentage from there we have a link to the Split account name.
This is the overall layout:
My question is at a transaction level how do I assign the Split perctage to of Sale to SLS 1 and then SLS 2?
Hey,
based on your PBIX I created this measure, I'm not sure if TOT_SALES is the measure of your interest, but basically you can adjust this measure to your needs:
Total_Sales Split = SUMX(VALUES('factSales'[groupKey]) ,SUMX( 'bridgeSalesGroup' ,[TOTAL_SALES] * CALCULATE(MAX('bridgeSalesGroup'[Split %])) ) )
This allows to visualize a simple table:
Please be aware that due to the content of the bridge table, currently the measure results into a larger splitted value.
Hopefully this is what you are looking for.
Regards,
Tom
Hey,
this is a really interesting challenge.
But without some sample data, this will be unfortunately to cumbersome.
Please consider to create some sample data, upload a PBIX file to onedrive or dropbox and share the link.
Regards,
Tom
Any help would be greatly appreciated.
Hey,
currently I'm surfing through your data and I'm wondering about the split that is configured for the grpkey = 88.
I see this split:
Is this correct?
Regards,
Tom
It is not. It appears there us a data entry error. SLS Key 67 should not be included in grp key 88.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |