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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
swhitty
Frequent Visitor

Percentage of Total

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_0-1657905608306.png

 

1 ACCEPTED SOLUTION
swhitty
Frequent Visitor

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

 

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

View solution in original post

3 REPLIES 3
swhitty
Frequent Visitor

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
Community Support
Community Support

Hi, @swhitty 

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

Best Regards,
Community Support Team _ Eason

lbendlin
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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