Forum Discussion

sdukes_88's avatar
sdukes_88
Frequent Visitor
9 years ago
Solved

% of total

Hi,   I know I can do this with a quick calc but wanted to be able to name the column and format the percentage.   I've followed another example but my rows are always 100%   Import % of Total ...
Need Help
  • prathy's avatar
    prathy
    9 years ago

    Hi,

     

    Are you after something like this?

    Import % of Total = var bigTotal =  CALCULATE(SUM(Table1[Actual]),ALL(Table1))
    return DIVIDE(SUM([Actual]),bigTotal)

prathy's avatar
prathy
Icon for Advocate III rankAdvocate III
9 years ago

Hi,

 

Are you after something like this?

Import % of Total = var bigTotal =  CALCULATE(SUM(Table1[Actual]),ALL(Table1))
return DIVIDE(SUM([Actual]),bigTotal)

sdukes_88's avatar
sdukes_88
Frequent Visitor
9 years ago

Exactly that! Thank you so much!!