Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Afternoon All,
I am a new to Power BI, so apologies if the below has already been covered in earlier posts.
We have invoice values that we need to apportion royalty payments to. As our products have multiple royalties applicable against them I am looking to calculate an appotioned value per item for each aplicable royalty code, and then calculate the royalty applicable to each item / royalty code combination.
The apportioned values that I have work okay except for grand totals which are sadly incorrect.
Below are headers from two data tables that I am linking for this purpose, is there a failsafe formula that I can use to get correct values throughout my table / matrix ?
Invoice Data Table |
Invoice No |
Customer A/c |
Item No. |
Item Description |
Posting Date |
Quantity |
Unit Price |
Line Value |
Royalties Table |
Item No. |
Royalty Code |
Royalty Description |
Royalty Apportioned Value (%) |
Royalty % Applicable |
Any help / guidance would be much appreciated.
Solved! Go to Solution.
You may take a look at the following post.
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
You may take a look at the following post.
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Many thanks for the link, this solution works perfectly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |