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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anno2019
Helper IV
Helper IV

Include individuals with no activities

Dear Guru's

 

I have 3 Tables 

1.  'Employees' A list of all employees  // a master list of all Employees which has a relationship with 'Invoice DATA' based on employee name, there is only 1 column in this table which is [Employee Name].

2.  'Invoice DATA' The number of invoices completed per Sales Person // data has mulitple columns which include [Employee Name], [Date of invoice] & [# Invoices] etc

3.  'Country list' A list of all our countries // a master list of all our countries which has a relationship with 'Invoice DATA' based on [Country name], there is only 1 column in this table which is [Country Name]

 

As expected, when I use the 'Invoice DATA', I can generate a list of Employees and the number of invoices per Employee.  

BUT, this list using 'Invoice Data' will only show you the Employees who actually have completed any invoices, obviously would not show any data for employee WITHOUT any invoices.

 

I was hoping if I start off with a base list from the table 'Employees' [Employee Name] that I could then see a list of all Employees and for those employees that have No data in the table 'Invoice DATA' then it will show 0.

But I am unable to succeed because i also need to be able to filter for Country.

Any Ideas?

1 ACCEPTED SOLUTION

@Anno2019 , please find the attached file after signature

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Anno2019 

Add +0 to your formula.

 

Also, try Show item with no data for employee

ShowItemwithoutdata.JPG

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak 

I do not have any formula's except # Invoices.

 

perhaps it will be easier if I share an example file.

https://www.dropbox.com/s/a0pd6ce2btnypn0/Show%20List%20of%20Employees%20without%20any%20invoices.pb...

@Anno2019 , please find the attached file after signature

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak, worked perfectly!  Thank you

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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