% calculation

[Anonymous]

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_AE	Current_Minimum	Lost_Business_prem
a	1952533	2840919
b	2156028	2,840,919
c	1621874	31946654
d	1549861	2,840,919

[AlB · Accepted solution]

Hi @Anonymous 

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