Help with calculating percentage

[Anonymous]

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 'Title' column. 

In this example the total sum of descendants = 29, and there are 21 of those in a Descendants.State of 'Done'.

So trying to figure out how I get the 0.724 answer 🙂 

Any thoughts?

[mussaenda]

Hi @Anonymous,

I think you will need the function ALL on the second part of your statement

like  divide(sum(Descendants.Count), calculate(sum(Descendants.Count), all(your tablename))

Hope this helps

[Anonymous]

Sorry not quite clear on what the measure should be, are you saying it should be:

PercentageComplete = DIVIDE(CALCULATE(SUM(FeatureProgress[Descendants.Count])),CALCULATE(SUM(FeatureProgress[Descendants.Count]),ALL(FeatureProgress),FeatureProgress[Descendants.State] = "Done"))

[amaleranda]

@Anonymous 

change your denominator and numarator inside the divide function.

[Anonymous · Accepted solution]

Got it!

Answer is:

%complete = DIVIDE(CALCULATE(SUM(FeatureProgress[Descendants.Count]),FeatureProgress[Descendants.State] = "Done"), CALCULATE(SUM(FeatureProgress[Descendants.Count])))

[mussaenda]

Hi @Anonymous,

Like this?

% = DIVIDE(SUM(FeatureProgress[Descendants.Count]), CALCULATE(SUM(FeatureProgress[Descendants.Count]), ALL(FeatureProgress)))

Sorry I didn't read that you only need for DONE.

Try this:

% for Done = 
CALCULATE([%], 'FeatureProgress'[Descendants.State] IN { "Done" })

Hope this helps

[Anonymous]

Sorry that still doesn't work for me:

[mussaenda]

Well then,

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

Sorry for not able to help you solve your problem.

[amitchandak]

@Anonymous , Try a new measure like

divide(calculate(sum(Table[descendants.count])),calculate(sum(Table[descendants.count]),table[descendants.state]= "Done"))

[Anonymous]

Thanks for the quick reply! That doesn't look to be quite right: