Percentage of Total

[swhitty]

Hey! 

I am looking to find the abandonment rate per agent, and the total abandonment percentage of all agents. I should be getting a total of 3.40, but as you see below .. it's not calculating the way I need it to.

= #abandoned/# presented

What am I doing wrong? Beginner here 😞 

[swhitty · Accepted solution]

My apologies for not being as descriptive, but I found my measure. Thank you!

% Abandoned Measure = DIVIDE(SUM(Transactions[# abandoned]),SUM(Transactions[# presented]))

[v-easonf-msft]

Hi， @swhitty 

Can you show the relevant formulas you are currently using for #abandoned/# presented?

Best Regards,
Community Support Team _ Eason

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523