topic Dax calculation assistance in Desktop
https://community.powerbi.com/t5/Desktop/Dax-calculation-assistance/m-p/318848#M141849
<P>Hi could you help me?</P><P> </P><P>I could do this calculation in Excel, but DAX is entirely new to me.</P><P> </P><P>Column 1 has names the following names in each row eg John, Fred, Jane<BR /><BR /></P><P>Column 2 has the states the total population of potential leads in the respective areas for those in column 1 eg 50, 70, 90 (in each of the first 3 rows).</P><P> </P><P>Column 3 lists how many leads that John Fred and Jane made contact with eg 20, 40, 50.</P><P> </P><P>John Fred and Jane need to make contact with 95% of leads over the quarter. I need to calculate a measure showing how many lead contacts needed for John Fred and Jane to reach the 95% target.</P><P> </P><P>The formula will look like this: Measure = (0.95 * Total Population) - Leads made contact with</P><P> </P><P>or: Measure = (0.95 * column 2) - column 3</P><P> </P><P>How do I write that in DAX?</P><P> </P><P>The actual data is below.</P><P> </P><P>So I need to calculate the following:</P><P>Measure = (0.95 * Base Population) - Enrolled</P><P> </P><P>How do I write that in DAX?</P><P> </P><P>Where can I learn how to write formulae in DAX? Thanks so much Power BI experts!</P><P> </P><P>Thanks so much :-<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 600px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/73244i33755D8536BCF2F5/image-size/large?v=v2&px=999" role="button" title="image.png" alt="image.png" /></span></P>Thu, 07 Dec 2017 03:08:25 GMTpowerbi-learner2017-12-07T03:08:25ZDax calculation assistance
https://community.powerbi.com/t5/Desktop/Dax-calculation-assistance/m-p/318848#M141849
<P>Hi could you help me?</P><P> </P><P>I could do this calculation in Excel, but DAX is entirely new to me.</P><P> </P><P>Column 1 has names the following names in each row eg John, Fred, Jane<BR /><BR /></P><P>Column 2 has the states the total population of potential leads in the respective areas for those in column 1 eg 50, 70, 90 (in each of the first 3 rows).</P><P> </P><P>Column 3 lists how many leads that John Fred and Jane made contact with eg 20, 40, 50.</P><P> </P><P>John Fred and Jane need to make contact with 95% of leads over the quarter. I need to calculate a measure showing how many lead contacts needed for John Fred and Jane to reach the 95% target.</P><P> </P><P>The formula will look like this: Measure = (0.95 * Total Population) - Leads made contact with</P><P> </P><P>or: Measure = (0.95 * column 2) - column 3</P><P> </P><P>How do I write that in DAX?</P><P> </P><P>The actual data is below.</P><P> </P><P>So I need to calculate the following:</P><P>Measure = (0.95 * Base Population) - Enrolled</P><P> </P><P>How do I write that in DAX?</P><P> </P><P>Where can I learn how to write formulae in DAX? Thanks so much Power BI experts!</P><P> </P><P>Thanks so much :-<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 600px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/73244i33755D8536BCF2F5/image-size/large?v=v2&px=999" role="button" title="image.png" alt="image.png" /></span></P>Thu, 07 Dec 2017 03:08:25 GMThttps://community.powerbi.com/t5/Desktop/Dax-calculation-assistance/m-p/318848#M141849powerbi-learner2017-12-07T03:08:25ZRe: Dax calculation assistance
https://community.powerbi.com/t5/Desktop/Dax-calculation-assistance/m-p/318885#M141873
<P>So, the formula should be something like:</P><P> </P><PRE>Measure = (SUM([Base Population]) * .95) - SUM([Enrolled])</PRE><P>As a column, you could just do:</P><P> </P><PRE>Column = ([Base Population] * .95) - [Enrolled]</PRE><P>Parenthesis around the multiplication are not strictly necessary given order of operations.</P>Thu, 07 Dec 2017 04:46:33 GMThttps://community.powerbi.com/t5/Desktop/Dax-calculation-assistance/m-p/318885#M141873Greg_Deckler2017-12-07T04:46:33ZRe: Dax calculation assistance
https://community.powerbi.com/t5/Desktop/Dax-calculation-assistance/m-p/319804#M142348
<P><SPAN class="">smoupre you're amazing mate!!</SPAN></P><P> </P><P><SPAN class="">your solution worked perfectly!</SPAN></P><P> </P><P><SPAN class="">You're a Power BI Expert!!!</SPAN></P><P> </P><P><SPAN class="">Thanks mate!</SPAN></P>Fri, 08 Dec 2017 05:51:20 GMThttps://community.powerbi.com/t5/Desktop/Dax-calculation-assistance/m-p/319804#M142348powerbi-learner2017-12-08T05:51:20Z