Forum Discussion

Sut_Datanaut's avatar
Sut_Datanaut
Helper II
4 years ago
Solved

% 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...
  • Anonymous's avatar
    Anonymous
    4 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