Absolute at total

[Omega]

Dears,

I am currently trying to calculate the absolute difference between imports and exports at SKU level in the total. For the same SKU, I have imports and exports in every week. At the end of week 8, I'd like to check the absolute difference between Imports and Exports. How?

[vanessafvg]

what is your actual requriement here?   

you want to divide it into some of the skus but not all?

can you tell me what your end goal is, ie the business requirement

[Omega]

Requirement: Calculate Abs(Export - Import)/Export at SKU level, week level and month level assuming month level have been already defined based on the weeks. 

We have many SKUs and it's impossible to filter them. We need a general measure that does the calculation regardless of the numbers of SKUs. 

Thanks!

[vanessafvg]

alright i am just trying to understand the problem

do you want all the sku's or just certain sku's, so what i am saying how will power bi know what sku's to use?  is there an indicator that is applied to them. the ones you need to use. what is the condition that will include them in the calculation

[Omega]

It should be all SKUs. 

Imagine in excel::

You have a list of SKUs that have exports and imports in different weeks (Same as the one I shared in my first post but with multiple SKUs). You will create a column that will get you the absolute difference for each SKU which is the measure we have created earlier. At the end, you will sum up the exports and the absolute diffenence for all SKUs and then you will will divide the summation of absolute difference to the total exports to get a percantage. This percentage will be at SKU level. 

So in my example, 470/8510 = 5% for that SKU.

I hope I'm clear.