Rate calculation summing entire data set

[Anonymous]

Hi all, I am new to Power BI. I am trying to calculate a Rate % column based on sum(Numerator)/sum(Denominator) by Measure ID field. However, the Rate keeps calculating by the entire data set rather than slicing by Measure ID field. This is also with "Don't Summarize" on for the Rate. Please see below.

Measure ID	Num	Den	Rate %	What Rate should be
ABA	41765	43994	0.916468	0.949334
ART	1091	1344	0.916468	0.811755952
BCS	15923	20967	0.916468	0.759431488
CDC	23792	23792	0.916468	1

Any help is appreciated.

[Anonymous]

Hi @Anonymous

If you are looking for calculated colum, you can use divide them directly.

CColumn= Num/Den.

If you are looking for Measure,

Measure = SUM(NUM)/ SUM(DEN).

If you still face issue, please share more details along with the formula you use.

Thanks

Raj

[ryan_mayu · Accepted solution]

@Anonymous

Do you want to create a measure or a column? I tried your formula to create a measure. It works fine. Could you please provide more detailed info on your issue?

RATE = SUM(Table2[NUM])/SUM(Table2[DEN])

[Anonymous]

@ryan_mayu, thank you! I did not know the difference between the two yet. I tried creating a measure and it works perfectly. Simple fix. Thanks again.

[dedelman_clng]

How are you calculating Rate? Please provide the code.

Also whether it is a calculated column or a measure.