Want to calculate the procentage between two column values

[Anonymous]

Hi!

I have tried alot of stuff with trial and error without success.

I want to calculate the procentage of two values. Example below:

Her i want to calculate how much in procentage i have left on safety stock.
If we divide Avail Qty / Safety Stock (Q) = 320*2400 = 0,13 or 13% that means that we are -87% from the safety stock amount which is correct.

However, when i have more than one value as can be seen below:

the procentage adds into a total procentage. What i want is to only calculate Avail Qty / Safety Stock (Q) = 201/300 = 0,67 or 67% and then be able to vizualize whats left in other words 0,33 or -33%

My calculated column for the safety stock table:

Safety Stock % = IF(INVENTORY_CURRENT[Safety stock]=0,1,INVENTORY_CURRENT[AvailableQuantity]/INVENTORY_CURRENT[Safety stock])-1

Hope that the information helps and that someone can aid me.

Kind Regards

[varunsabu]

Please try the following measure

[Anonymous · Accepted solution]

Hi @Anonymous ,

Calcualted column will show total only based on easy aggregation logic like SUM/AVG... and so on.

I suggest you to create a measure to achieve your goal.

Safety Stock % = 
DIVIDE(SUM('INVENTORY_CURRENT'[Avail Qty]),MAX('INVENTORY_CURRENT'[Safety stock (Q)])) - 1

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.