Calculate the % of one stock in a subgroup

[Anonymous]

Hi, I'm trying to calculate the percentage of one asset in a subgroup.
I have my table with all assets (Stocks, REITs, Bonds, Crypto), I calculated the percentage of one investment in the total, but I want to know the portion of GOOG just when the type is stocks.

% Current = 'Transfer'[Current Price]/sum('Transfer'[Current Price])

Total = SUM('Transfer'[Current price])

Total Stocks = CALCULATE(SUM('Transfer'[Current Price]),'Trasfer'[Type]="Stocks")

% Stocks = (DIVIDE([Total Stocks],[Total]))

[amitchandak · Accepted solution]

@Anonymous , if you want for sun group then

% Stocks = (DIVIDE([Total Stocks],calculate([Total], filter(all(Table), Table[Sub Group] = max(Table[Sub Group]) ) ))

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho