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 

[Jay2022]

Great thank you

[Arjun_TK · Accepted solution]

You can use below dax function to get your expected result.
% Remaining = 100 - [% Increase]

Replace % Increase with the actual name of your column if it differs

If your percentages are in decimal format (like 0.60 instead of 60%), adjust the formula accordingly:

% Remaining = 1 - [% Increase]

then use this in your barchart,hope this works.

[Greg_Deckler]

@Jay2022 Try 1 - [% increase]. If that's not it, then post sample data.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.