Division Showing Total in All Fields

[Stuznet]

Hi all,

I'm struggling to get this right. Basically, I want Table 2 display the correct value just like Table 1 instead of 100%. 

 

Here is the Report pbix

Can someone please help me?

Thanks

[Stuznet · Accepted solution]

I found the answer. All I need is to add All(Item at the end

Total Portfolio = DIVIDE([Sales 2 Total] + [Sales 1 Total],CALCULATE(SUM(Data[Value]),ALL('Item')))