Forum Discussion
Absolute at total
divide(SUMX(Table2,[Measure]),calculate(SUMX(Table2,Table2[Export]), filter(table2, sku = 8510 && sku = 111))
Thanks but again, this will not solve the problem. Assume that I have one million SKUs, I won't be able to type all 1 million SKUs :(
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
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!
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
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.