Matrix Hierarchy measure totals wrong for divide

[learnerdax]

Hi Dax experts,

I need help with Matrix measure totals , im getting wrong totals for Hierarrchy, if i use divide in measure,Please help me with this.Need calculate total for Country wise as well as by state and by City.Pleae could any of you help me with this.

[tamerj1]

Hi @learnerdax 

does that also mean, the country values in the first matrix is wrong? It sould be always the sum of its states and the state should always be the sum of its cities?

[learnerdax]

Yes, in First Matrix Sales/Qty and down matrix 
USA - 550(State Cal -350+Flo -100+Tx-100)
UK   - 300(same for UK states)
total -850

[tamerj1]

@learnerdax 

If so please try

Sales/Qty =
SUMX (
SUMMARIZE ( Hierarchy, Hierarchy[Country], Hierarchy[State], Hierarchy[City] ),
CALCULATE ( DIVIDE ( SUM ( Hierarchy[Sales] ), SUM ( Hierarchy[Qty] ) ) )
)

[learnerdax]

Thank you so much @tamerj1 ,It worked.