Want to calculate procentage between two values with a calculated column

[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

[v-janeyg-msft]

Hi, @Anonymous 

If you want to change the value according to your choice, you can't use calculated column, you need to change it to measure. The screenshot is too small to see anything. Can you share clearer data and graphs?