Forum Discussion
Post PatronCalculate Sales contribution % on specific items
Hi hidenseek9 ,
I updated the sample pbix file(see the attachment) again, please check if it is what you expected.
Best Regards
Hi hidenseek9 ,
I created a sample pbix file(see the attachment), please check if that is what you want.Fee 2 =
Best Regards
Post PatronAnonymous
Thank you!
This works perfectly.
However, is there a sum to show the right figures?
For instance,
- % needs to add up to 100% and not 131.91%.
- Fee 1 total should show as 1% of sum of sales and not 79M
How can we achieve this?
Hi hidenseek9 ,
I updated the sample pbix file(see the attachment), please check if it is correct now...
Best Regards
- hidenseek9
Anonymous
Thank you! Now the total is showing up to be 100% but the subtotal is incorrect now.
AND1% should add up to 26.7% and subtotal amount should add up to 16.0M.
Same issue persist for Fee2.
Can this be solved?Hi hidenseek9 ,
I updated the sample pbix file(see the attachment) again, please check if it is what you expected.
Best Regards