subtracting 100 from each value in another column

[Jay2022]

i have % increase in one column eg 60%, 80% for various organisations and i want to show the remainder eg 40% and 20% in another so i can show stacked bar charts etc how do i create a column which deducts 100 from each percentage 

i tried something like % remaing = 100 - % increase but that didn't work 

Any help greatly appreciated 

[v-fenling-msft · Accepted solution]

Hi, @Jay2022 

I am glad to help you.   

According to your description, you want to calculate the remaining percentage？ 

If I understand you correctly, then you can refer to my solution.  

I created a simple dataset based on your description: 

Then use the following DAX formula for New Column in Power BI Desktop: 

Remaining Percentage = 
1 - [Percentage Increase]

Remember to change the type of the corresponding column to Percentage: 

In my tests, this DAX formula works: 

You can refer to my steps to test it again and if you still have problems, please provide some sample data in text format (excluding sensitive data) in the form, or even better if you can provide a simplified pbix file. Thanks! 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.