Desktop

Frequent Visitor
Posts: 2
Registered: ‎01-17-2019

Rate calculation summing entire data set

[ Edited ]

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.

Accepted Solutions
Established Member
Posts: 183
Registered: ‎09-17-2018

Re: Rate calculation summing entire data set

@byrnel0586

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])`

All Replies
Highlighted
New Contributor
Posts: 450
Registered: ‎08-25-2016

Re: Rate calculation summing entire data set

[ Edited ]

How are you calculating Rate? Please provide the code.

Also whether it is a calculated column or a measure.

Established Member
Posts: 183
Registered: ‎09-17-2018

Re: Rate calculation summing entire data set

@byrnel0586

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])`

Super User
Posts: 668
Registered: ‎11-01-2017

Re: Rate calculation summing entire data set

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

Frequent Visitor
Posts: 2
Registered: ‎01-17-2019

Re: Rate calculation summing entire data set

@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.