PivotTable Rows: show all values from one column without duplicating it from the other column

[probexcel]

Hi guys,

I have two tables:

1. Master Table: contain the list of all customers we need to monitor the sales
2. Sales Data: we update it every week with year to date sales for the customers in the master table

MASTER TABLE SNIPPET

Customer ID	Customer Name
12345	Customer 1
12346	Customer 2
12347	Customer 3

SALES DATA SNIPPET

Customer ID	Date	Units
12345	01/04/2023	12
12345	01/05/2023	12
12345	01/10/2023	24
12345	01/12/2023	12
12346	01/05/2023	12
12346	01/06/2023	24
12346	01/11/2023	24

My ideal output would be a pivot table where shows EVERY customer from the Master Table. I created a Power Pivot Connection between the tables, and from that data model I created the Pivot Table.

Now, I wanted to show the Customer 3 with Sum of Units as 0. I created a measure value to show 0 when the Sum of Units is blank:

=IF(ISBLANK(SUM(SalesData[Num Units])),0,SUM(SalesData[Num Units]))

But the problem with that is that it's now repeating the dates:

I don't want to show the dates with no values, I just wanted to show the dates when there's a sale to that Customer.
Is there a way to achieve that?