Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with calculating percentage

Hi Guys,   Wanted some help with a dataset I'm currently working with (table name - FeatureProgress):                 I'm trying to calculate the percentage of completed work for the...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Got it!

     

    Answer is:

    %complete = DIVIDE(CALCULATE(SUM(FeatureProgress[Descendants.Count]),FeatureProgress[Descendants.State] = "Done"), CALCULATE(SUM(FeatureProgress[Descendants.Count])))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry that still doesn't work for me:

 

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
6 years ago

Well then,

I hope the experts here would be able to help you.

 

Sorry for not able to help you solve your problem.