Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
AlB
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.