Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to find the total number of emails received and sent within a mailbox

I have connected my mailbox and want to see the total count of emails received within the inbox and how many have been sent. Please can someone help? I have attached my current dashboard. 



Super User III
Super User III

You probably shouldn't provide sample data for that. Is your company using pictures in the email signature?

Frequent Visitor

Thanks @lbendlin 

I have looked at the contents of the HasAttachments column and it seems every email does have an attachment. How do I filter so only data within the HasAttachmnts is displayed? 

Super User III
Super User III

As you noticed the counts in your cards are the same. That's the total number of emails in all folders.  Now all you need to do is add a folder filter for sent and inbox.


(If you really want to know how many emails had attachments you need to look at the contents of the HasAttachments column, not just count its rows.)

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors