Forum Discussion
Sut_Datanaut
4 years agoHelper 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 percentag...
- Anonymous4 years ago
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
4 years agoHelper II
The columns got messed up, but essentially the volume in 2,2,6,40,60,95 and the Stores are Store A, B, C