Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply

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 :-image.png

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

smoupre you're amazing mate!!

 

your solution worked perfectly!

 

You're a Power BI Expert!!!

 

Thanks mate!

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.