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

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.