cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
byrnel0586
Helper I
Helper I

Rate calculation summing entire data set

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.

1 ACCEPTED SOLUTION
ryan_mayu
Super User II
Super User II

@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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
rajendran
Resident Rockstar
Resident Rockstar

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

ryan_mayu
Super User II
Super User II

@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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

@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
Super User II
Super User II

How are you calculating Rate? Please provide the code.

 

Also whether it is a calculated column or a measure.




Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors