Divide categories total by baseline total

Hi,

As per our understandings you are looking for a column based on some Conditions,
Here what I have found for Reaching to your Requirement,

Initially we have to Create Calculated column with below Dax Expression,

Custom_Carbon =

var Basline =
IF('Sample table'[Carbon] = "Baseline 19/20",'Sample table'[Total],0)

return
Basline

Thereafter we can Create our vs Column with below dax Expression

vs =

var result =
DIVIDE('Sample table'[Total],MAX('Sample table'[Custom_Carbon]),0)

return ROUND(IF(result =
1,BLANK(),result),2)

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at [email protected]

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/