Help With DAX Percentages

[Anonymous]

Hi all, hope it's an easy one just struggling a little with DAX for something very simple when calculating percentages 

In excel the formula is 

=(C61-C62)/C61

or for what i'm doing its: 

=(Total calls - Missed calls)/Total Calls 

to give me the total calls answered. 

I'm just struggling to replicate this, any advice? 

[parry2k · Accepted solution]

@Anonymous sorry I gave you the wrong calculation, BTW, if you already have measure for missed call % then use then 2nd option

Answered Calls % = 
1 - DIVIDE ( SUM ( YourTable[MissedCalls] ), SUM ( YourTable[TotalCalls] ) )

or

Answered Calls % = 
1 - [Existing Missed Called % Measure]

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Thank you so much! That's solved it 🙂

[Anonymous]

@parry2k unfortunately that's not worked the answer i'm looking for is 88% to corrallate with the missed calls percentage which is accurate as per the below. 

[parry2k]

@Anonymous Add a measure using the following expression to calculate Answered Calls %

Answered Calls % = 
1 - DIVIDE ( SUM ( YourTable[TotalCalls] ), SUM ( YourTable[MissedCalls] ) )

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

@parry2k here's a screengrab of the columns i'm interested in. Each row is a call (indicated by the 1 in call count) and each missed call is also indicated by the 1 in the Missed Call Count column. I'm interested in the percentage answered. The percentage missed is 12% which was easy to figure out but the elusive calculation I described above to get the 88% figure or (calls answered) is what I'd like to know. Thanks for taking the time to read. 

[parry2k]

@Anonymous you need to share sample data, it is very hard to reply without knowing the data. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490