How to fill a table I have

[TheKiltedGolfer]

Attached is spreadsheet of sample data called “Ticket Data.”  I really need someone’s help to learn how to write the code to fill this table based “Opened” date and Employee.  For EVERY day I need to have a total number of tickets opened by each employee.  As you can see from the sample data, an employee may not open a ticket every day but I still need to have every employee represented for each day even if their total is ZERO.  I am thinking I need a separate table of active employees, which I have attached as well called “Employees.”  However, I have no idea where to start in order to get the data I need.  Once I have this then I will produce a bar/line chart combo where the bars represent tickets opened by each employee by date with the line above the bars representing total tickets opened by date.  Can anyone please assist me in what is needed to fill this table with the data I need?

[v-chuncz-msft]

@TheKiltedGolfer 

You may try Show items with no data and take a look at the posts below.

• https://community.powerbi.com/t5/Desktop/Create-a-Clustered-Column-Chart-using-Two-Summarize-Measure...
• https://community.powerbi.com/t5/Desktop/Percentages-to-multi-line-report/m-p/378504#M172040

[TheKiltedGolfer]

Sorry but your suggeestions did not work.  As a matter of fact, the first link to the first post you provided produces the same combo graph I have now. BUMMER.  I hope someone out there has other suggestions.