Wrong Totals in Matrix Hierarchy

[prakash11440278]

Hi Power BI Experts,

I am using matrix chart and added the attributes interms of hierarchy. I am getting wrong data in main total where as i am getting correct in last two levels. Below is the formula i am using. 

Result: 

(7167302*31.103480)/52846785=4.14 ( which is wrong)

Expected Result:

(7167302*31.103480)/52846785=4.22 ( Correct)

[PaulDBrown]

Please define the measures involved in the calculation. Thanks

[prakash11440278 · Accepted solution]

Hi @PaulDBrown ,

Thanks for your reply. Below is the measure.

(SUM(Table[Column1])*31.103480)/SUM(Table[Column2])