Multi line chart running total percentage

[Anonymous]

I have a multi-line chart displaying 2 running total measures.

When displaying values as numbers, the graphs are correct:

Numeric Running Totals

I would like to display the values as percentages of the Planned Cumulative Total.

Displaying only the planned series by percentage looks as desired:

Planned %

As soon as I add the Completed series by percentage, it displays incorrectly since the Completed percentage is with respect to the Completed grand total instead of the Planned Grand Total:

Multiple %

How can I force the running Total % of my Completed series to be calculated with respect to the Planned Grand Total in the same chart?

Thank s in advance.

Ross

[MFelix]

Hi @Anonymous,

I believe that the best way is to calculate your measures in percentage and not in vslues and then do the calculated quick calc.

Try to have a look at the quick measures thst csn help you make this measures only by selecting the fields you need.

Regards,
MFelix

[Anonymous · Accepted solution]

@MFelix, I had a similar suggestion from a collegue.

Ultimately, the measure needed for my Closed line needed to consist of:

Running Pct Closed = 
VAR TotalPlanned = CALCULATE(SUM(Stories[Points Planned]), ALL(Stories))
Return DIVIDE([Points Closed (Cumulative)], TotalPlanned, 0)