Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 :-
Solved! Go to Solution.
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.
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.
smoupre you're amazing mate!!
your solution worked perfectly!
You're a Power BI Expert!!!
Thanks mate!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |