% of total based on additional fields (in same table)

[Sut_Datanaut]

Hi, 

I am trying to find a calculated column or measure forumla for a % of total volume based on the name and store. I would like the formula to sum each Names total, but then provide a percentage breakdown by the store. % of Volume by Store & Person is the column in the example below that i am trying to make. 

Thanks in advanced

Name	Store	Volume	% of Volume by Store & Person
Jim	Store A	2	20%
Jim	Store B	2	20%
Jim	Store C	6	60%
Kathy	Store A	40	40%
Kathy	Store B	60	60%
Joe	Store A	95	100%

[Anonymous · Accepted solution]

Hi  @Sut_Datanaut ,

Here are the steps you can follow：

1. Create calculated column.

Volume% of Volume by Store & Person =
DIVIDE(
SUMX(FILTER(ALL('Table'),'Table'[Name]=EARLIER('Table'[Name])&&'Table'[Store]=EARLIER('Table'[Store])),[Volume]),
SUMX(FILTER(ALL('Table'),'Table'[Name]=EARLIER('Table'[Name])),[Volume])
)

2. Result:

If you need pbix, please click here.

% of total based on additional fields (in same table).pbix

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Sut_Datanaut]

worked perfectly! Thank you

[Sut_Datanaut]

The columns got messed up, but essentially the volume in 2,2,6,40,60,95 and the Stores are Store A, B, C