cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rsd1989
Frequent Visitor

% calculation

Hi

 

I'm sure this is a fairly simple explanation but i'm having trouble doing this. Do i do this in a new measure?

 

Basically I have my data in a table which is a visualization as listed below what I want to do it add a new column in the table which is:

 

The table has been summed up by Current_AE

 

Lost_Business prem / (Lost_Business prem + Current Minimum) to give a %

 

Can anyone help?! 

 

Current_AECurrent_MinimumLost_Business_prem
a19525332840919
b21560282,840,919
c162187431946654
d15498612,840,919
1 ACCEPTED SOLUTION
AlB
Super User
Super User

Hi @rsd1989 

Are  [Lost_Business prem]  and [Current Minimum] explicit measures? If so, you can just create an additional measure, format it as %, and place it in your visual

 

NewMeasure = DIVIDE( [Lost_Business prem],  [Lost_Business prem] + [Current Minimum])

 If they are implicit measures, create explicit ones (writing the formula).   

View solution in original post

1 REPLY 1
AlB
Super User
Super User

Hi @rsd1989 

Are  [Lost_Business prem]  and [Current Minimum] explicit measures? If so, you can just create an additional measure, format it as %, and place it in your visual

 

NewMeasure = DIVIDE( [Lost_Business prem],  [Lost_Business prem] + [Current Minimum])

 If they are implicit measures, create explicit ones (writing the formula).   

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.