Let me first show you what I mean here

In Excel I am doing this to calculate the % breakage on total stones

But in power BI, I cant divide the stones per type of breakage or colour by the total of stones

This is how my data set is looking? maybe its wrong format?

Now my formula in power bi is the following

% Breakage Stones = [Stones]/(calculate(sum(‘Breakage Data’[Total Stones]),‘Breakage Data’[Colour]=“Total”))

Any help will be appreciated, thanks