Forum Discussion
Helper II% of total based on additional fields (in same table)
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% |
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
3 Replies
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_Datanautworked 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