Forum Discussion
% 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 ...
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).
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).