100 - measure %

Question

Hi All,&nbsp;I have a measure based on two calculated column as below:&nbsp;&nbsp;Deployed % = DIVIDE ('Calls'[NAD],[TED],0)&nbsp;Calculated Columns are&nbsp; as:NAD = SUM(Calls[New Agent Deployed])TED = SUM('Calls'[Total EndCalls])&nbsp;Measure "Deployed %" give me result in graph as:&nbsp;&nbsp;&nbsp;&nbsp;Now I want to show other part of 57.4 % too as Non Deployed %.&nbsp;Probbaly I need to create new measuer in which existing measure deduct form 100.&nbsp;&nbsp; 100 - Deployed %&nbsp; &nbsp;= Non Deployed.&nbsp;Nees help here.&nbsp; &nbsp; Any other alterantive will aslo be apprreciated.&nbsp; &nbsp;Thanks&nbsp;&nbsp;

sdhn · Accepted Answer

Non Deployed % = (1&nbsp;-&nbsp;[Nessus Deployed %])&nbsp;This works&nbsp;

Forum Discussion

100 - measure %

2 Replies

Related content

Cumulative measure / 100

IF morethan %100

IF morethan 100

conditional format a measure that is over 100%

Exam DA-100