Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Measure Called Leads =<br><span class="Keyword" style="color:#0070FF">CALCULATE</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">DISTINCTCOUNT</span><span class="Parenthesis" style="color:#969696"> (</span> Query1[LeadId] <span class="Parenthesis" style="color:#969696">)</span>,<br><span class="indent4"> </span>'Query1'[LeadStatus] <> <span class="StringLiteral" style="color:#D93124">"Duplicated"</span>,<br><span class="indent4"> </span>'Query1'[LeadStatus] <> <span class="StringLiteral" style="color:#D93124">"Wrong Number"</span>,<br><span class="indent4"> </span>'Query1'[LeadStatus] <> <span class="StringLiteral" style="color:#D93124">"New"</span>,<br><span class="indent4"> </span>'Query1'[LeadStatus] <> <span class="StringLiteral" style="color:#D93124">"Dialler Attempted"</span>,<br><span class="indent4"> </span>'Query1'[LeadStatus] <> <span class="StringLiteral" style="color:#D93124">"Attempted"</span>,<br><span class="indent4"> </span>'Query1'[LeadStatus] <> <span class="StringLiteral" style="color:#D93124">"Not Reachable - 5 Attempts"</span>,<br><span class="indent4"> </span>'Query1'[LeadStatus] <> <span class="StringLiteral" style="color:#D93124">"Not Reachable - 5 Attempts (Open)"</span><br><span class="Parenthesis" style="color:#969696">)</span><br>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement