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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
sdhn
Responsive Resident
Responsive Resident

100 - measure %

Hi All,

 

I have a measure based on two calculated column as below:

 

 Deployed % = DIVIDE ('Calls'[NAD],[TED],0)
 
Calculated Columns are  as:
NAD = SUM(Calls[New Agent Deployed])
TED = SUM('Calls'[Total EndCalls])
 
Measure "Deployed %" give me result in graph as:
sdhn_0-1644364270799.png  

 

 

Now I want to show other part of 57.4 % too as Non Deployed %.

 

Probbaly I need to create new measuer in which existing measure deduct form 100.

 

  100 - Deployed %   = Non Deployed.

 

Nees help here.    Any other alterantive will aslo be apprreciated.   Thanks 

 

1 ACCEPTED SOLUTION
sdhn
Responsive Resident
Responsive Resident

Non Deployed % = (1 - [Nessus Deployed %])

 

This works 

View solution in original post

2 REPLIES 2
sdhn
Responsive Resident
Responsive Resident

I wrote this 

 

Non Deployed % = (100 - [Nessus Deployed %])
 here is  a result
 
sdhn_1-1644366366892.png

 

It should be 57.4 %

 

See measure "Deployed % "in first post.   Thanks 

 

sdhn
Responsive Resident
Responsive Resident

Non Deployed % = (1 - [Nessus Deployed %])

 

This works 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.