Dividing the sum of a columns

[TechMike]

Hi, 

I'm new user of power bi and I am stuck with this problem. I am trying to get the qoutient of the SUM of two columns (See the table below). 

Province	Adjusted Amount	Obligation Incurred	OBLIGATION RATE (OBLIGATION INCURRED/ADJUSTED AMOUNT
A	100	90	90 %
B	450	450	100 %
C	231	208	90 %
TOTAL	781	748	95.77 %

But I get this in power bi

Province	Adjusted Amount	Obligation Incurred	OBLIGATION RATE (OBLIGATION INCURRED/ADJUSTED AMOUNT
A	100	90	90 %
B	450	450	100 %
C	231	208	90 %
TOTAL	781	748	280 %

How can i correct this? I've also tried to create a new measure with this 

ObRate = DIVIDE(H[OBLIGATIONS INCURRED],H[ ADJUSTED ALLOTMENT ])

 And still got the 280% result. It
Any help would be greatly appreciated.

Thank you.

[TechMike]

Hi @bhanu_gautam ,

Thank you for the prompt reply. I've tried to follow your suggestion. With this measure,

And still I was not able to get the results I wanted. 😞

[v-rzhou-msft]

Hi @TechMike ,

Please make sure you are creating a measure instead of a calculated column.

If you create a calculated column, it will a summarize result based on the rate column.

Measure will show the aggregation result you want.

ObRate = 
VAR _Obligation_Incurred = SUM(H[Obligation Incurred])
VAR _Adjusted_Amount = SUM(H[Adjusted Amount])
RETURN
DIVIDE(_Obligation_Incurred,_Adjusted_Amount)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[wini_R]

Hey @TechMike,
Please try the following formula:

Hope it helps!

[TechMike]

Hi @wini_R ,

Thank you for the suggestion. I've tried your suggestion. But still didn't get the result i wanted. I am trying to get this result (see the pic below).

The measure you have suggested gets the OB Rate on the provinces but not on the total. The Power BI just added up the qoutients of the two columns.

Thanks.

[bhanu_gautam]

@TechMike , Use below measures

TotalObligationIncurred = SUM('YourTable'[Obligation Incurred])

TotalAdjustedAmount = SUM('YourTable'[Adjusted Amount])

TotalObligationRate = DIVIDE([TotalObligationIncurred], [TotalAdjustedAmount])