% measure

[master_student]

Hello Community,

I have a graph with 2 measures as you can see bellow and I need to add another measure to calculate the % consumed of the budget

What is the formula?

Thanks for your help

[swuehl]

Maybe like

= Column(1) / Column(2)

or

="Actual PO" / "Budget"

and setting the number format on number tab to percentage.

[sunny_talwar · Accepted solution]

I think you might want to move the third expression to the right axis as the budget and Actual PO might be huge values and the % might be too small to be visual on the same axis.

Pick your third expression from the Expressions above and select Right (Top) option

[master_student]

Thanks Sunny and Swuel. I combined your solutions and the result is :