Reply
Frequent Visitor
Posts: 2
Registered: ‎01-17-2019
Accepted Solution

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 IDNumDenRate %What Rate should be
ABA41765439940.9164680.949334
ART109113440.9164680.811755952
BCS15923209670.9164680.759431488
CDC23792237920.9164681

 

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

c1.JPG

 

View solution in original post


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

c1.JPG

 

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

Re: Rate calculation summing entire data set

Hi @byrnel0586

 

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

Rate.PNG

 

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.