Using Power BI

Create the following measures: Movement Value - Quantity x Wav Cost Excl. Hint: use SUMX Sum of Goods Receiving Value - Movement Value filtered by document type. Sum of Goods Returns Value - Movement Value filtered by document type. Net Purchases Value - Sum of Goods Receiving + Sum of Goods Return. Sum of Branch Transfers In Value - Movement Value filtered by document type. Sum of Branch Transfers Out Value - Movement Value filtered by document type. Net Transfers Value - Sum of Branch Transfers In plus Sum of Branch Transfers Out Value. Net Movement Value - Net Purchases Value plus Net Transfers Value. Total Net Movement - Ignore filter context. Hint: check out the CALCULATE and ALL function in DAX.

by importing the data into power bi as .csv

Total Net Movement Percent - Net Movement Value divided by Total Net Movement.