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