Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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% |
Solved! Go to 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
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
worked perfectly! Thank you
The columns got messed up, but essentially the volume in 2,2,6,40,60,95 and the Stores are Store A, B, C