cancel
Showing results for
Did you mean:
Helper I

## Dax calculation assistance

Hi could you help me?

I could do this calculation in Excel, but DAX is entirely new to me.

Column 1 has names the following names in each row eg John, Fred, Jane

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).

Column 3 lists how many leads that John Fred and Jane made contact with eg 20, 40, 50.

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.

The formula will look like this: Measure = (0.95 * Total Population) - Leads made contact with

or: Measure = (0.95 * column 2) - column 3

How do I write that in DAX?

The actual data is below.

So I need to calculate the following:

Measure = (0.95 * Base Population) - Enrolled

How do I write that in DAX?

Where can I learn how to write formulae in DAX? Thanks so much Power BI experts!

Thanks so much :-

1 ACCEPTED SOLUTION
Super User IV

So, the formula should be something like:

`Measure = (SUM([Base Population]) * .95) - SUM([Enrolled])`

As a column, you could just do:

`Column = ([Base Population] * .95) - [Enrolled]`

Parenthesis around the multiplication are not strictly necessary given order of operations.

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

2 REPLIES 2
Super User IV

So, the formula should be something like:

`Measure = (SUM([Base Population]) * .95) - SUM([Enrolled])`

As a column, you could just do:

`Column = ([Base Population] * .95) - [Enrolled]`

Parenthesis around the multiplication are not strictly necessary given order of operations.

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Helper I

smoupre you're amazing mate!!

You're a Power BI Expert!!!

Thanks mate!

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.