Customers in report with 0 sales value not shown

[Anonymous]

Hi all, 

I have ran into a problem showing up the full customer list for a sales reporting. Consider a customer base:

Customer ID	Customer Name
2325	Cust1
3540	Cust2
4056	Cust3
8090	Cust4

and POS report:

Customer ID	POS value	date
2325	50	01.11.2022
3540	30	01.11.2022
4056	45	01.11.2022
2325	20	01.11.2022
3540	10	02.11.2022
3540	30	02.11.2022
4056	45	02.11.2022
2325	10	03.11.2022
3540	25	03.11.2022
4056	8	03.11.2022

As you can see the customer with ID=8090, Cust4 has no POS. Therefore PowerBI does not include this customer into the Table reporting:

How it's possible to add this customer, and show up 0 POS value in the reporting?

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Create a POS Value measure like this:

_posValue0 = SUM(Table2[POS value]) + 0

Then use Table1[Customer ID] and Table1[Customer Name] in your visual (assuming Table1 is related to Table2 on a Dimension:Fact basis) with your new measure.

Pete