Divide measure is not showing the correct total

[tejapowerbi123]

Hello Community,

My formula is working fine but total is not showing right numbers for Matrix Visuals.
Measure = DIVIDE(SUM('Totals'[Plan Rate]),SUM('Totals'[Invoice]),0)

I also tried the second measure formula but not working for me.

Measure = sumx(Totals,DIVIDE(SUM('Totals'[Plan Rate]),SUM('Totals'[Invoice]),0))

Dataset: 1 (Region)

Region	Country
USA	Newyork
CANADA	Toronto
Europe	London

Dataset:2 (Market)

Market	Derived
BioPharma	Bio
Clinical	Cli
Forensic	For

Dataset:3 (Totals)

Plan Rate	Invoice	Country	Derived	Country
5	1		Bio	Newyork
10	2		Cli	Toronto
15	3		For	London
25	4		Bio	Country
30	5		Cli	Newyork
35	6		For	Toronto
40	7		Bio	London
45	8		Cli	Country
50	9		For	Newyork

[vojtechsima · Accepted solution]

Hello, @tejapowerbi123 
So, something like this?

I created 3 measures, Sum of Invoice, Sum of Plan Rate and your Division:

Total Plan Rate = SUM('Totals'[Plan Rate])

Total Inovice = SUM('Totals'[Invoice])

Divided = SUMX('Totals', DIVIDE([Total Plan Rate], [Total Inovice], 0))

[tejapowerbi123]

@vojtechsima  Thank you so much your help