Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

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 = S...
  • sdhn's avatar
    sdhn
    4 years ago

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

     

    This works 

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
4 years ago

I wrote this 

 

Non Deployed % = (100 - [Nessus Deployed %])
 here is  a result
 

 

It should be 57.4 %

 

See measure "Deployed % "in first post.   Thanks 

 

  • sdhn's avatar
    sdhn
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

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

     

    This works